Viewing 15 posts - 391 through 405 (of 1,069 total)
suraj.app (11/28/2011)
I need to script my local database to my client's server. I need to script in such a way that if the sp / table exists in the client...
November 28, 2011 at 11:18 pm
cjohn5552 (11/28/2011)
Is it due to one of the logs of the system databases becoming very big as a result of restoring such a database?
No. This can not be...
November 28, 2011 at 10:40 pm
azhar.iqbal499 (11/28/2011)
November 28, 2011 at 1:20 am
satvinder.atwal (11/21/2011)
3. Can we physically create check point?
No. Checkpoint is an action. It happens. Checkpoint is not an object.
You can manully initate it.
But you cannot "physically create" it.
November 27, 2011 at 11:11 pm
swapnil.d13 (11/25/2011)
can I update only source connection string in ssis package? Please help..
Yes, it is possible.
Created package configaration file.
Open your package in BIDS. Click on SSIS menu. Select "Package configuration..."
Package...
November 27, 2011 at 10:37 pm
Saga... (11/24/2011)
can you suggest me exact steps. And step by step index rebuilding process. as this is production db.
Sagar,
My suggestion to you is... if you are not sure about...
November 24, 2011 at 11:58 pm
Are you sure replication is causing deadlocks?
In which server are you having deadlocks, publisher or subscriber?
Are the replicated tables involved in deadlocks?
Do you delete/update the rows from replicated tables in...
November 15, 2011 at 10:20 pm
apoggioli (11/14/2011)
"Errors related to feature availability and configuration: The 'Database storage location' feature is not included in the '64 Bit Standard Edition' SKU.(Microsoft.AnalysisServices)"
Don't click on 'Database storage location'. This feature...
November 15, 2011 at 4:37 am
Yes. There are reasons to avoid DETACH/ATTACH.
Mohammed Moinudheen has already mentioned a good reason.
If replication is involved, do not use detach\attach method. You would have to drop replication entirely in...
November 3, 2011 at 11:37 pm
crazy4sql (11/3/2011)
what are the best pratices for Moving Database files from one location to another location?
Points to be considered :-
1) Must have enough space at new location for files to...
November 3, 2011 at 5:06 am
mohnish_khiani (11/2/2011)
Why the order by clause cannot be used in the query which makes up the query in a view??
Not only in SELECT statement, views be used in other DML...
November 2, 2011 at 5:30 am
Add the new table as an aritcle to the publication and generate snap shot.
October 30, 2011 at 11:48 pm
The reason is expression is NOT allowered there.
Try this:
select @MyEmail = useremail,@MyFirstname=firstname+' have a good day!' from #MyTempTable where id = @MyId
...
October 24, 2011 at 2:55 am
Sumanta Roy (10/20/2011)
what about multiple rows in testing.dbo.users? mail will be sent sent to the first one. Rest will be missed.
I think this takes care of that:
select @MyEmailString =...
October 20, 2011 at 5:25 am
vinodkumar.kasturi072 (10/20/2011)
how to create log in in SQLServer200R2
There are different "kind" of logs in SQL Server. Which log you are talking about?
October 20, 2011 at 4:23 am
Viewing 15 posts - 391 through 405 (of 1,069 total)