Viewing 15 posts - 31 through 45 (of 186 total)
I need to use SQL server 2008 because it' the latest SQL server which is supported in XP, there are many customers present who still uses the Windows XP operating...
November 14, 2016 at 12:33 am
ChrisM@Work (9/8/2014)
IT researcher (9/8/2014)
September 9, 2014 at 3:54 am
patrickmcginnis59 10839 (9/8/2014)
Talib123 (9/8/2014)
Do it via T-sql and set identity insert on-- SET IDENTITY_INSERT to ON.
SET IDENTITY_INSERT products ON
GO
It really sounds like he tried this, but in the destination...
September 9, 2014 at 12:35 am
ZZartin (9/8/2014)
Can you just not import that column? That should let the identity column on the destination table work like it's supposed to.
How can i import data without one...
September 8, 2014 at 7:31 am
GilaMonster (6/12/2014)
IT researcher (6/12/2014)
June 12, 2014 at 7:18 am
GilaMonster (6/12/2014)
IT researcher (6/12/2014)
The sql server starts everyday at 8:30 AM and stops around 9:30 PM.
June 12, 2014 at 6:53 am
Why?
SQL instances don't need to be rebooted daily. Hell, I know of instances that have been running over 6 months.
The SQL server instance is used by employees in office....
June 12, 2014 at 6:50 am
Now i again took the report and found PAGEIOLATCH_SH is still at the top and have value of wait_time_ms 11067000.
The sql server starts everyday at 8:30 AM and stops around...
June 12, 2014 at 6:28 am
SQL server restarts every night. Does these values reset on restart?
June 12, 2014 at 5:43 am
This question has posted twice(by mistake) check here http://www.sqlservercentral.com/Forums/Topic1533511-391-1.aspx
But you can answer for the question there.Also how can I delete this question as it is double posted?
January 22, 2014 at 2:37 am
Can anyone help me to troubleshoot the said problem?
January 21, 2014 at 1:11 am
Also a nice explanation here for my question.
January 20, 2014 at 11:41 pm
The DB only has one initial size in reality, the size it was first created with. This is the size relevant to the shrinkfile operation
So can i change the size...
January 16, 2014 at 11:07 pm
sreekanth bandarla (11/14/2013)
2.Check for FAT32/NTFS - If FAT32, I think you need to specify TABLOCK option(Am not 100%...
November 18, 2013 at 12:55 am
To avoid lot of auto-growth i have set the initial size to 100 mb based on the size and content of database.
September 25, 2013 at 11:46 pm
Viewing 15 posts - 31 through 45 (of 186 total)