SQL Server 2005 (onwards): SELECT * FROM sys.traces SQL Server 2000 : USE msdb SELECT * FROM fn_trace_getinfo(default); Ref: fn_trace_getinfo Column descriptions for sys.traces DMV can be found here: sys.traces
You are trying to restore a SQL Server 2000 database on SQL Server 2012. This is not supported. You will need to restore your database on an instance of SQL Server 2005, 2008 or 2008 R2 first, then back it up from there, then restore the new backup on SQL Server 2012. Microsoft explains this … Read more
You can write multiple cases, even if they all have the same condition. ORDER BY CASE @OrderByColumn WHEN 1 THEN Forename END DESC, CASE @OrderByColumn WHEN 1 THEN Date END, CASE @OrderByColumn WHEN 1 THEN Location END, CASE @OrderByColumn WHEN 2 THEN Surname END ASC Actually, you don’t specify a column to sort by, but … Read more
No, SQL Server Express LocalDB doesn’t accept remote connections. The idea with shared network folder might work, but only if you are able to make sure the LocalDB instance is shutdown before you try to copy the file. Also keep in mind that only one LocalDB instance can have any given database file open at … Read more
From the column_constraint page on MSDN: ON DELETE { NO ACTION | CASCADE | SET NULL | SET DEFAULT } Specifies what action happens to rows in the table that is altered, if those rows have a referential relationship and the referenced row is deleted from the parent table. The default is NO ACTION. So, … Read more
When using XML in SQL Server you can try to cast to a data type and receive null values where the cast fails. declare @T table ( Col varchar(50) ) insert into @T values (‘1’), (‘1.1’), (‘1,1’), (‘1a’) select cast(” as xml).value(‘sql:column(“Col”) cast as xs:decimal ?’, ‘decimal(28,10)’) as Col from @T Result: Col ————- 1.0000000000 … Read more
Right click your database in your server, and select Tasks > Generate Scripts. At Introduction step, click Next. At Choose Objects, you can either select either the entire database (including functions, and etc) or specify what objects you want to generate. In your case, you should select Script entire databases and all database objects then … Read more
The DATEPART function has a tz option which returns the value’s UTC offset in int minutes. DATENAME also supports the tz option and returns the formatted UTC offset in the form [+-]HH:MM Note that a datetimeoffset value only contains a scalar UTC offset value, it does not contain any time-zone information at all (as multiple … Read more
This can be done with a check constraint that verifies null value and matches the result with or create table #t (i int , j int , constraint chk_null check (i is not null or j is not null)) The following are the test cases insert into #t values (null, null) –> error insert into … Read more
Package Executions: SQL Server Data Tools: User credentials under which SQL Server Data Tools (SSDT) is operating will be used to execute the packages that are executed within SSDT. Under Windows Start \ All Programs \ Microsoft SQL Server 2012, if you click SQL Server Data Tools it will run under your credentials. To run … Read more