Probably most people already know – but it still happens often to me: When restoring a SQL database you cannot login even though the database user matches the SQL Server login. This can easily be fixed with the following command:… Read moreAttaching User to a Login (SQL Server)

Here are the T-SQL database scripts I most frequently use when trouble-shooting. — Clear transaction log for SQL Server 2008 and after (log file) USE [DatabaseName] DBCC SHRINKFILE(‘TransactionLogLogicalName’, 1) BACKUP LOG [DatabaseName] TO DISK=’NUL’ DBCC SHRINKFILE(‘TransactionLogLogicalName’, 1)   — Clear… Read moreFavourite database scripts

Hvis det er nødvendigt at slette al data i alle tabeller i en SQL Server database kan følgende T-SQL script hjælpe: — Source: http://vadivel.blogspot.com/2006/07/easiest-fastest-way-to-delete-all.html Set nocount on Exec sp_MSForEachTable ‘Alter Table ? NoCheck Constraint All’ Exec sp_MSForEachTable ‘ If ObjectProperty(Object_ID(”?”),… Read moreSlet al data i SQL Server database

Der findes nogle muligheder for at sende e-mail fra en SQL 2000 server med fordele og ulemper: SQL e-mail. Det er sql serverens indbyggede e-mail forsendelse, som kræver at en e-mail klient er installeret på serveren. Det vil man ikke… Read moreSend e-mail fra sql server