RE: Dynamic SQL Queries
quote: set @sqlstring = N'select * from ' + @DBName Silly question, but what's the significance of the "N" before the select (N'Select)?
2003-11-20
security
RE: I/O errors in error log
Sorry, Mike, I misunderstood your posting. I believe that DBCC is kind of randomly spitting out errors. The "CHECKDB..." errors being displayed for the table that has 0 rows are some examples of this. Dropping/recreating the table with 0 rows made no difference. I did try running dbreindex on 2 of the larger tables, thinking […]
2003-11-19
RE: DatabasePermissions vs ObjectPermissions
Gotta love the docs. Andy http://qa.sqlservercentral.com/columnists/awarren/
2003-11-19
2003-11-19
2003-11-19
1 reads
RE: Site Certificate
OK, I killed a Google component. Do you still see it? Brian Knight bknight@sqlservercentral.com http://qa.sqlservercentral.com/columnists/bknight
2003-11-18
RE: Stored Procedure error.
Bay the way 8.00.194 is the RTM version of SQL Server. Don't you think you should update to SP3a?
2003-11-18
RE: Stored Procedure error.
The table you are trying to update has a trigger called 'Movement' that uses RAISERROR to generate an ad-hoc error mesage if update attempted.
2003-11-18
1 reads
RE: Multi-server administration
Can you retrieve the event logs even if the workstation is not registered on the domain? Also, how do you monitor remote jobs statuses? By querying the sysjobhistory table? JM
2003-11-17
RE: Database Integrity Checks on Database Backup.
Thanks guys, your input is much appreciated. Just to clarify, the reason for this issue arising is that we only have an absolute maximum of 15 minutes per day when we are allowed to do anything detramental to the system, despite many arguements over the point. Thus with a Full Backup taking priority during this […]
2003-11-17
Blogs
Back to Boston for SQL Saturday
By Steve Jones
I’m leaving again tomorrow for a trip. This time I head back to Boston...
T-SQL Tuesday #179: What’s In Your Data Detective Toolkit?
By Tim Mitchell
Most of us who work with data have, at least a few times, been...
The Future of the Social Web Is in Good Hands
By Rob Sewell
The Social Web Foundation is aiming to grow the fediverse and make the social...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers