Sorry about that. Here is what the error message says:The server detected the following syntax errors in the command: Error 7314: OLE DB provider 'server2' does not contain table 'Rbc_datawarehouse.dbo.cmsbatch'. The table either does not exist or the current user does not have permissions on the table. OLE DB error trace [Non-interface error: OLE DB […]
2004-08-25
Just give the user access to their own database and not any other database.In Enterprise Manager, drill down to Security, expand that and click on Logins. Find the Login that you want to check, and double click on it. Go to the Database Access tab. Make sure that only the database the user needs to […]
2004-08-10
He is a good article on this subject.http://:www.databasejournal.com/features/mssql/article.php/3319261
2004-08-10
I have tried all these options but it is not consistent. 1. SQL Query Analyster - >Tools -> Connection Properties -> Unchecked the SET ANSI_WARNINGRight click on the tempdb and refreshExecute the script. Initially for 4 to 5 times it gives the warning and it doesn't give.2. Tried setting this option to the database it gives […]
2004-07-29
I have a column that is varchar (255) and need to change it to text. That's the easy part. The column is in a table that contains a sequence number that tracks the number of rows because the column must be concatanated together for display. The original database was version 6.5 that did not have […]
2004-06-23
1 reads
Right-click on the maintenance plan and select "Maintenance Plan History". This is where you'll find much more descriptive error messages.
2004-05-05
Timberwood,We are currently using the MSAccess / SQL Server configuration that you are using. We have approximately 330 users with about 30 users connected at one time. These Access dbs were created in '99 and use a combination of DAO (run queries against the linked tables) and ADO to exec Stored Procedures against SQL Server. […]
2004-05-03
UNION probably works have not tested it, but other option would be to build a temp table with dates to join against or perform sub-query within.
2004-04-13
Sure you can! Take a look at sp_spaceused in BOL. I would also search the script section here. This will surely return several useful hits.
2004-04-08
Well, There will be many instances where Cursors come handy and even performance efficient while doing batch updates, so I believe that outrightly we cannot make a statement that Cursors are inferior to set statements, however it has to be decided on a case basis.Thanks
2004-04-06
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers