-
Subscribe
Subscribed
Already have a WordPress.com account? Log in now.
Using the following SQL one can find tables that contain a column name. In SQLServer SELECT table_name, column_name FROM INFORMATION_SCHEMA.COLUMNS… READ MORE
In SQLSever 2005 msdb.dbo.sp_send_dbmail is the new way of sending email and it replaces xp_sendmail. Below are the steps how… READ MORE
— List processes currently running through SQLServer Agent select spid, program_name, blocked from master..sysprocesses where program_name like ‘SQLAgent%’ spid program_name… READ MORE
Using the link below one can create SQL script to create database http://geekswithblogs.net/dotNETPlayground/archive/2008/04/18/121331.aspx READ MORE
Flash Tip: Running Profiler on a Busy SQL Server http://www.microsoft.com/technet/abouttn/flash/tips/tips_020205.mspx READ MORE
|
Run the following SQL to find permissions granted on users on the database select case when p.protecttype = 205 then… READ MORE
From the following KB article it list couple of store procedures which can be used to send email through SQLServer.… READ MORE
To display compatibility levels that can be set, 60 – 6.0, 65 – 6.5, 70 – 7.0, 80 – SQL… READ MORE
In SQL Server snapshot can be created which creates a point in time read-only copy of any database. The amount… READ MORE
Using the steps below one can change the location of the datafiles in SQLServer for user databases and tempdb. 1)… READ MORE
In Oracle there is CREATE TABLE…AS to backup table into a new table and the syntax on SQL Server is… READ MORE
“Control what I can control”
~ Alex Lima
Alex Lima 