Viewing 15 posts - 76 through 90 (of 149 total)
--Drop previous reporting database
----------------------------------------------------------
PRINT 'Check if DB exists if so drop'
GO
IF EXISTS(SELECT * FROM SYS.DATABASES WHERE NAME='ReportDB')
BEGIN
--Remove any connections
ALTER DATABASE ReportDB
SET SINGLE_USER WITH
ROLLBACK IMMEDIATE
--Drop DB
DROP DATABASE ReportDB
END
GO
setting db in single...
-----------------------------------------------------------------------------
संकेत कोकणे
November 16, 2012 at 5:08 am
In command prompt type
SQLCMD/?
It will show various options,which will help you to create batch file .
if you want to execute test.sql trough batch file , you can use
SQLCMD -Sservername...
-----------------------------------------------------------------------------
संकेत कोकणे
November 16, 2012 at 4:53 am
Casper101 (11/14/2012)
"Attachment file ***** is invalid"
The file does exist and the SQL login is sysadmin.
The file...
-----------------------------------------------------------------------------
संकेत कोकणे
November 14, 2012 at 12:44 am
rummings (11/12/2012)
-----------------------------------------------------------------------------
संकेत कोकणे
November 13, 2012 at 11:18 pm
Happy Diwali to all and have a great Year ahead 🙂
-----------------------------------------------------------------------------
संकेत कोकणे
November 13, 2012 at 10:09 pm
dsanchez-630020 (11/9/2012)
Is there away without shrinking the database to get back the space when we delete big files in our database?
did you try rebuilding your indexes ?
-----------------------------------------------------------------------------
संकेत कोकणे
November 12, 2012 at 2:52 am
there are so many similar posts like this , where some experts put there opinions, you can check there
http://www.sqlservercentral.com/Forums/Topic1361075-391-1.aspx
-----------------------------------------------------------------------------
संकेत कोकणे
November 12, 2012 at 2:46 am
Rebuilding clustered indexes can free up unused space.
But as you provide default value 20 GB to data file , it will not fall below 20 GB.
-----------------------------------------------------------------------------
संकेत कोकणे
November 12, 2012 at 2:39 am
You mean T-SQL developer or DBA ?
-----------------------------------------------------------------------------
संकेत कोकणे
November 12, 2012 at 2:35 am
Post DDL before CELKO come 😀
-----------------------------------------------------------------------------
संकेत कोकणे
November 9, 2012 at 4:58 am
do you have copy of mssqlresource database files before the installation of service pack .
if you are lucky and you have copy of these db files , you can...
-----------------------------------------------------------------------------
संकेत कोकणे
November 8, 2012 at 10:47 pm
You can use import export wizard .
and wherever you need data for specific date and dept ,use query in the import wizard
select * from yourtable where date ='date...
-----------------------------------------------------------------------------
संकेत कोकणे
November 8, 2012 at 10:36 pm
Koen Verbeeck (11/8/2012)
sanket kokane (11/7/2012)
I got it wrong ...you should mention sql server Version in question .
Sysdatetime () not present in sql 2000 and 2005
So, for which versions do you...
-----------------------------------------------------------------------------
संकेत कोकणे
November 8, 2012 at 4:34 am
McSQL (11/8/2012)
Forgot that this was a discountinued command in...
-----------------------------------------------------------------------------
संकेत कोकणे
November 8, 2012 at 4:29 am
Eugene Elutin (11/8/2012)
sanket kokane (11/7/2012)
My Table structure is like
create table test (id char (8))
I want , whenever user insert value ,lets...
-----------------------------------------------------------------------------
संकेत कोकणे
November 8, 2012 at 4:20 am
Viewing 15 posts - 76 through 90 (of 149 total)