I was trying to remove the Identity inserts for 4 tables all at once but I keeping getting errors like Cannot remove the Identity insert on table 2 as the table1 already has identity insert on. So after digging into the MSDN I was surprised to see the following lines “At any time, only one [...]
Displaying the most recent of 45 posts written by
Vivek
Problem: I was trying to configure the backups on Sql Server using the Maintenace Plan. When I opened it . I got the following error TITLE: Microsoft SQL Server Management Studio —————————— Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476 —————————— ADDITIONAL INFORMATION: An exception occurred while executing a Transact-SQL statement [...]
TSQL has improved its assignment Operators in the C language convention. In SQL SERVER 2000 or SQL SERVER 2005 the assignment operators are written as Declare @i int Declare @s varchar(100) set @i = 10 set @s = ‘WORD’ set @i = @i * 40 set @s = @s + ‘PRESS’ In SQL SERVER 2008 [...]
A new feature in Sql server 2008 TSQL is the Single Statement Variable Declaration. What is this? In Sql Server 2000 or Sql Server 2005 the declare statements are written as follows Declare @i int,@j int ,@k int set @i = 100 set @j = 200 set @k = 300 The Above Statement in Sql [...]
Policy-Based Management(PBM) is the expansion of advanced DDL trigger mechanisms on the Server. Think of the following things a. How do I allow the users to create the table in specific naming conditions like starting only with ‘T’? b. How about checking the availability of the latest Sql Server backups? c. How about limiting the [...]
