Search results for query: *

I have many pdf files which are to be stored in the database or the OS filesystem, but need to be accessed quickly by front end application. Is it possible to store pdf data in SQL Server or will the OS filesystem be a better option and how can I give fast access to this pdf data. Thanks Cricketer1

Can someone help me with....how to connect and import SYBASE Data into MS SQL Server. Thanks, cricketer1

How can I Import data tables from DB2 into MS Sql Server using DTS and Linked Server. Thanks, cricketer1

Can anyone help with the SQL to delete a PK constraint. Visually EM can handle this but I need to do this in QA. Thanks, Cricketer1

What is the difference between using IN and EXISTS in subqueries and which is preferred. Thanks

I have a scenario where a single coulmn of data is coming to me in an email on MS OutLook. How can I import this data into a table directly from the email, can this be automated too. Thanks

If a msdb database becomes suspect, how can it be recovered if there is no prior backup of msdb available. Already tried stopping and starting SQL Server Service, but didn't work. Thanks

I am using Win2000 Advanced Server, SQL Server Enterprise. I have a table that has over 700 columns, but I am able to replicate no more than 255 columns. How can I replicate the complete table? Thanks cricketer1

I have been getting problems when I try to backup my SQL Server database. Backup goes halfway and then stops with this error. Does anyone have any idea on how to tackle/resolve this, or where to start looking for clues. ----> BackupMedium::ReportIoError: write failure on backup device...

How can I change the name of the database server with minimum disruptions. I already have some databases on it Thanks

I have a database with couple of dozen people querying through either web interface or client server apps. This is an old DB and has grown to a size that is now slowing down performance and results take longer to return. However, 90% of the time only recent data is queried, most of the old...

Is it possible to run a DTS package from a webpage (.HTML) and how? thanx cricketer1

how can I restore a SQL Server 2000 db to SQL Server 7.0? cricketer1

How do I write a query to get table names and there sizes (# of records) in a database. What sys tables and columns should I query. Thanks cricketer1

I am getting an Invalid pointer error in one of my steps running inside a DTS package. The same query runs fine within query analyser, but inside a DTS it gives this "Invalid Pointer" error. I don't know what this means. Has anyone else come across this situation nay leads??

If my SQL Server undergoes a domain change that has a different login than the current Windows Authentication, how can I set the Windows login authentication on SQL Server for the new domain? Thanks Cricketer1

Does anyone know of a Zip utility to zip SQL server DB backup files? It is not the regular Winzip or PKzip? cricketer1

Is it possible to perform admin tasks in SQL Server such as backup or restore from commandline. If so how can I restore a transactional log file from DB 'A' to DB 'B' on commandline. Thanks cricketer1

Can anyone help with how to execute a DTS package from within an ActiveX script. I have an ActiveX script step and during this step I want to execute another DTS package. Thx cricketer1

I have a table containing multiple duplicate records of email, name, address etc. I want to pull Unique records containg all fields based on email. How can I do this within one query? Thx cricketer1