See "Datadude and the Text Filegroup"

Well, it turns out that if a table used to have a LOB in it, then the Text Filegroup is preserved. Deleting the LOB...

I am migrating a Sybase app to SQL Server 2005 or 2008. There are a large number of BCP (in and out) scripts running on UNIX that point to the...

All SQL Server logins will always have those privileges granted to the public role within the msdb database. These privileges can be list by running:

exec msdb.dbo.sp_helprotect @username =...

To diagnose the root cause when a client is attempting to connect and receives error 18456 with a error description of "Login failed for user '<user_name>'. (Microsoft SQL Server, Error:...

How curious about object creation in another database ! I have done this for tables but never for views.

use master

go

CREATE VIEW tempdb.dbo.tables AS

SELECT * FROM msdb.INFORMATION_SCHEMA.TABLES;

Fails with error:

Msg...

the problem is the "use database" statment and the solution is to specify the database name as part of the view name.

Replace

SET @sql = N'USE ' + @DESDB +...

Below is the source for a trigger solution.

I have made two assumptions:

1. The value of column DOTNumber in table TrailerInventory cannot change.

2. All updates to column...

Did you check for blocking before restarting SQL Server ?

From your original post:

The command I got from the profiler is the first one in my first post. As I said, this command is generated by the .Net runtime...

Are you certain that your data in in UTF-8 ? If all of the data is actually ASCII, a sub-set of UTF-8, then you can just use a varchar...

"data stored in nvarchar field is number but in UTF-8"

This is not possible as national characters in SQL Server are stored in UCS-2 (Universal Character Set 2 byte) and ...

SchemaBinding can only be used with views that only reference objects within the same database. Referenced objects can be tables, views and user defined functions.

For views that use distributed queries,...

MS has indicated that support for procedure cache configuration will not be provided despite this being requested by many SQL Server MVP. See "Amount of RAM for procedure cache should...

http://lmgtfy.com/?q=sla+%22sql+server%22+site%3Ablogs.msdn.com

To list all modules where an "execute as" has been specified, you can run the below SQL.

SELECTobjects.type_desc AS ObjectTypeDescription

,objects.type AS ObjectTypeCd

,SCHEMA_NAME(objects.SCHEMA_ID) AS SchemaName

,objects.nameAS ObjectName

,USER_NAME(sql_modules.execute_as_principal_id) ExecAsUserName

,objects.SCHEMA_ID

,sql_modules.execute_as_principal_id

FROMsys.objectsAS objects

JOINsys.sql_modulesAS sql_modules

ON sql_modules.OBJECT_ID= objects.OBJECT_ID

WHEREsql_modules.execute_as_principal_id...