It is probably running under a different user account from CR Viewer. Find out what that account is and make it a table owner. Or make a user role an...

Tha statement you are creating is this:

SELECT *

FROM table

WHERE ColumnName =columnName

ORDER BY desc

I think you meant something like this:

SELECT *

FROM table

ORDER BY columnName desc

So change...

Just login to Query Analizer as sa and execute

sp_password 'old_password', 'new_password'

I hope you are not looping through 20,000 rows using a cursor or WHILE loop. If you are, change it so you do the UPDATE/DELETE in one/two statements whithout a...

This will do the work:

DECLARE@delimited_stringVARCHAR( 100 )

,@start_positionSMALLINT

,@end_positionSMALLINT

SELECT@delimited_string = '2541,2542,5362,36585,36884'

,@end_position = 1

CREATE TABLE #list

(start_positionSMALLINT NOT NULL

,end_positionSMALLINT NOT NULL

)

WHILE @end_position > 0

BEGIN

SELECT@start_position = @end_position

,@end_position = CHARINDEX( ',', @delimited_string, @end_position + 1...

Well design your file system so that you do not have 100K in one folder; use subfolders instead.

1 GIG database is not that big. A warehouse I worked on was...

BLOB types are slow in general and by nature. BLOB data is stored separately from data pages, only a pointer is stored on the data page.

It is a good idea...

No, it could not. It is a special one. But try it.

Greg is correct. The way I manage changes to database structure is this. I never make changes through Enterprise Manager, only through Query Analyser using SQL script file, ne file...

If your question is how you know that table structure has changes since the last time you checked, you could use sysobjects.schema_ver column value:

SELECT schema_ver FROM sysobjects WHERE name =...

This is not possible. It would be too dangerous due to lack of full logging of such an operation.

It is a problem with any linked server connection, even when both sides are on SQL Server. Basically, you cannot send the kill command to a linked server. Well, imagine...

I prefer using TOp 1 instead of SET ROWCOUNT 1. It is less code and you do not need to set it back. SET ROWCOUNT is an old way, before...

But why a cursor is used here anyway? Cursors should not be used except in some special cases. Using sursors in the linked server environments sounds very scary. Based on...

1. Run "sp_who2 Active" to see all the active prossese including the one that is blocked. See what Process ID blocks it (number in the column BlkBy; if dot instead...