Search results for query: *

Are there performance improvements to be made from allocating different tables in a database to different data files. How would we work these out?

We want to use SAS to read data from SQL Server databases, we do not want to write. Is acquiring SAS/ACCESS the only way?

Thanks for your responses, it turns out the mdf file was compressed and SQL Server doesn't like compressed files.

I am using DTS to load data into a table from a SPSS file. This has worked for several tables so far with no problem. However now I'm getting the above message. The database is 40 Gb in size, there is 580 Gb free on the disk. There is no restriction to the size of the database and it is set to...

Unfortunately that did not work, it produced the error message "Rowset does not support fetching backward

Yes, in the debug print the value of the parameter is correct and I have run some examples in Query Analyser and it works.

I have a problem with the following code; in the debug.print statement the value of rsJuvos.recordcount is always -1. There is nothing wrong with the data; using an alternative method of passing the SQL statement as a string works. Can anyone spot the problem? Private Sub GetRecords2(NINumber...

I have a table in a master Access database. I want to open a series of other databases in turn and add to/update the contents of the master table with the contents of a similar table in each other database. I use ADO to make the connections. Can this be done using a SQL command? If so, how?

How do I set a field of type "smalldatetime" in an SQL Server database to be null using VBA? I've tried the following: tempDate = GetDateField(301) Debug.Print "DateUpd="; tempDate rs!DateUpd = tempDate GetDateField returns the 10 characters from an input string starting...