Viewing 15 posts - 751 through 765 (of 1,179 total)
what error message are you getting?
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
June 2, 2010 at 7:33 am
I do have second thought about the First part of the question.
As clearly mention "Consider the following table" and table says about the IDENTITY Column!! Hence we can understand that...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 20, 2010 at 4:12 am
Hello Ron
I liked QOD... Really appreciate your efforts to bring hidden things to public. I feel question could have been formed better but that is absolutely managable. Though I...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 20, 2010 at 3:57 am
Instead of any third party tool... Yes replication is surely better option. Schedule the job to distribute the data nightly from Publisher to subscriber. Also the advantage is you can...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 15, 2010 at 1:41 am
you can also refer "sysfilegroups"
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 15, 2010 at 1:08 am
sp_helpfile
will also give you the filegroup info. Also you can refer FILEGROUP_NAME check following link for detail
http://msdn.microsoft.com/en-us/library/ms176088.aspx
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 15, 2010 at 1:05 am
If you have not performed any full backup in between Old full backup and latest differential backup than yes you will be able to perform the restore.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
March 30, 2010 at 4:51 am
There are two ways:
1. Create Trigger on the table
2. Enable SQL Profiler for only one specific table and desire action.
HTH
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
March 26, 2010 at 7:18 am
I guess it could be possible. As two different instance on a same server will be distinguised by the different tcp/ip port. Hence I guess what you are planning to...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
March 24, 2010 at 7:03 am
You have to create maintenance plan. But it is possible that you do not include any backup step. Also you can have only deleting files Task to your maintenance.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
March 24, 2010 at 6:46 am
CHECK rebuildm.exe utility for sql 2000
And for SQL Server 2005 refer this link:
http://msdn.microsoft.com/en-us/library/ms191431(SQL.90).aspx
HTH
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
March 24, 2010 at 4:30 am
Yes, it is quite possible if you are using sql 2005 or higher.
Create a Maintenance plan and select maintenance cleanup Task. Go to property of the Task and there you...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
March 24, 2010 at 4:20 am
Yes, that is the security file created during the SQL Server installation.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
March 24, 2010 at 4:11 am
This clearly mentions that Database is recovering. The recovering process is a transient state; where database will automatically become online if the recovery succeeds. In case the recovery fails, the...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
March 24, 2010 at 4:03 am
If you would like to create a Batch file simply do BCP out of a table into text and text file will be your batch file.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
March 4, 2010 at 4:07 am
Viewing 15 posts - 751 through 765 (of 1,179 total)