Search results for query: *

FROM BOL: sp_table_privileges Returns a list of table permissions (such as INSERT, DELETE, UPDATE, SELECT, REFERENCES) for the specified table(s). Syntax sp_table_privileges [ @table_name_pattern = ] 'table_name_pattern' [ , [ @table_owner_pattern = ] 'table_owner_pattern' ] [ , [...

It could be that SQL EM or agent is holding a lock on the access mdb. The error is being generated by JET or Access. This could mean that SQL or a SQL agent is holding a lock on the database. Try this: When you get the above error. Explore the folder that contains the Access mdb. If there is a...

Only backup files can be restored. Backup file are a compressed file format an look nothing like the database or backup files that are mounted. My suggestion is this. Backup the database and transaction log. This will create a backup file for the database and the log file. Restore the database...

Is it possible that the sa name and password has been changed? It appears that the sa username and blank password (which is the default) is no longer a valid username and/or password. Try to use another login that has sa writes and try again. Good luck SQLRickster

If you use a DSN less connection string the ODBC drivers for the client or the database you are connecting to can change which will cause an error. It is safe to use DSN less connection as long as the drivers stay compatable. Rick

My bad. The statistics one is auto update statistics not auto create statistics....

If your indexes are not corrupted, then type the Query in Query Analyizer. Click the and view the query plan that SQL is going to run. If this is a large table and there is a table scan in your query plan, then it may take days to come back. Place a unique clustered index on a unique column and...

No worries. If your feeling lucky you can use QA to do the same task sp_dboption '<<database name here>>','torn page detection','ON' and sp_dboption '<<database name here>>','auto create statistics','ON' Rick

Kind os a predicament here. master db contains the information concerning SQL Server system tables/extended SP's and of course keeps track of who is where on the disk. This is initialized during start up of SQL Server. Since it is impossible to get SQL up and running, the only option is to...

Stopping and Starting SQL Server is the only way to kill these types of &quot;hung&quot; spids as far as I know. SQLRickster

You could actually embed Excel into a form using OLE. This will give you all of the power of Excel. This may not be what you want. Depends on what you need the grid to do. You could use a standard grid control and not bind the control to a data source. Getting data into the grid would require a...

If I understand the scenario correctly: The login at OS startup does not have the proper security settings, therefore the startup of SQL Server fails. Set the service to use a specified account when it starts in place of the users login. This is administered in Administrative Tools under...

DTS is the quickest and most efficient way to copy data from one table to another. Truncate the destination table. (Deleteing will cause logging and slow the operation down.) and DTS the new data into the destination table. Hope this helps, SQLRickster

darkradar what is the error message? Once we know that we may be able to help. Compatability is a broad subject. Thanks, SQLRickster

By Personal edition I take it to mean MSDE, which is SQL Server with a few governers. If you already have Enterprise Mananger and Query Analyizer installed locally, then it is a matter of registering the local instance in a SQL Server Group once MSDE is installed. To register the local instance...

If this is an Update or Insert trigger than the rec_id will be in the inserted table and will be called rec_id. For example: SELECT REC_ID FROM INSERTED This will give you the rec_id's of the records that have been changed. If this is a DELETE trigger it will be in the deleted table. SELECT...

This is a shot in the dark, but run sp_dboption '[database name here]','select into/bulkcopy' in Query Analyizer. If this is set to OFF, then DTS logs the insertion of all 1.4 million rows and you may be hitting a size wall. Set the db option to ON by runnning sp_dboption '[database name...

I did not notice that you are installing MSDE. If you downloaded the latest and greatest from M$ the instructions are: Instructions Click the Download link to start the download. Do one of the following: To start extracting files required to install MSDE immediately, click Open or Run this...

The installation is asking for you to define a strong password for the SA account. SA is the System Administrator and is GOD as far as SQL goes. A Strong Passowrd is one that uses mixed case and numbers. For example &quot;Dfem&22df$*&quot; is a strong password. The username can be sa. Enter a...

My suggestion is to find a local tech or IT school and take a few &quot;SQL Server 101 classes. Do not take a Theory class, but a &quot;hands on&quot; or &quot;now let me do it&quot; class. I do not want to be an infomercial but ITT Tech, New Horizon or ECPI can fill the bill. If taking this...