Viewing 15 posts - 871 through 885 (of 2,008 total)
baabhu (12/14/2011)
If you are having identity columns, why are inserting the values through application.Please use column names in the insert statement and exclue the identity column.
Agree. It's true...
December 14, 2011 at 12:57 am
Ninja's_RGR'us (12/13/2011)
TheSQLGuru (12/13/2011)
...That would be one HELL of a typo! 8 extra characters that actually spell out 2 appropriate words!?! 😎
Go easy on the kid <new born>. ...
December 14, 2011 at 12:53 am
How to set passward of database in SQLSERVER 2008 so when ever in any Mode Authentication/Mixed Mode user try to go in database it asks for passward
SSMS will ask...
December 14, 2011 at 12:30 am
jamessdba (12/14/2011)
Hi,Thanks for the Reply
My requirement As A DBA i need to capture back end correction(done by DEV team) audit log report to send my Manager
Fine. I have one question...
December 14, 2011 at 12:21 am
Duplicate Post...
http://www.sqlservercentral.com/Forums/Topic1221358-338-1.aspx
December 14, 2011 at 12:17 am
jamessdba (12/14/2011)
Please let me know good maintenance plan for Production Database size >5GB
Any proper order like (rebuild index ,update statistics and database integrity etc...) Every weekend or Daily
Thanks in...
December 14, 2011 at 12:12 am
What's the issue Smith? You can anyways format PerfMon reports anyway you want.
December 14, 2011 at 12:07 am
jamessdba (12/13/2011)
Our requirement is
when ever any backend correction or applying patches(scripts) done @production SQlserver 2005 by our user (Ex : changes in objects(tables,proc,func,views,...)
how do i capture the...
December 14, 2011 at 12:04 am
Joy Smith San (12/13/2011)
December 13, 2011 at 11:55 pm
Agree with Koen. As long as you are not violating any licensing term, it’s fine.
December 13, 2011 at 11:42 pm
SET IDENTITY_INSERT [ database_name . [ schema_name ] . ] table { ON | OFF }
Please verify schema & table name in above command.
December 13, 2011 at 11:34 pm
engrshafiq4 (12/13/2011)
HI all,i am using jquery and asp.net using C#.i want to save data from CSV,XLSX,XLS etc directely to sqlserver 2005 database.
OR Simply asp.net using c# and sqlserver2005.
I think you...
December 13, 2011 at 11:30 pm
It also means you it will take much time to failover or you may lose data in forced failover.
It’s a serious issue. Please verify the mirroring states.
http://msdn.microsoft.com/en-us/library/ms189284.aspx
The following article is...
December 13, 2011 at 11:21 pm
sql_novice_2007 (12/13/2011)
In SSMS Object Explorer, selected database, right-clicked on the table and right clicked Storage and then I see only two options enables.
Create partition and manage...
December 13, 2011 at 9:14 am
Ninja's_RGR'us (12/13/2011)
chetanr.jain (12/13/2011)
sp_whoisactive == ?Does not seems to be familiar procedure.
can anybody post the code for this procedure.
Damn google, always down when you need it! 😉
damn... There is...
December 13, 2011 at 9:10 am
Viewing 15 posts - 871 through 885 (of 2,008 total)