Viewing 15 posts - 4,831 through 4,845 (of 7,191 total)
You can answer that one yourself. Use the DATEPART function again. If you don't know the syntax, you'll find it in Books Online or on the web.
John
January 6, 2012 at 4:24 am
Dan
I feel your pain. If you don't have the option to change the database, do you have the option to change the application? That way, you could perform...
January 6, 2012 at 4:22 am
But it won't look for the database name on the other server - that's the whole point. If you don't know the database name then you can't do anything....
January 4, 2012 at 4:31 am
That won't work. Why do you want to build your SQL statement dynamically? It's the same statement you're going to execute no matter what environment you're in. ...
January 4, 2012 at 4:16 am
Well, if you don't know the database name, you're stuck. Can you not just ask the owner of the server? Once you find out the name of the...
January 4, 2012 at 3:57 am
How is the database name determined? If you're always passing in the same name, that doesn't sound very dynamic. Maybe what you need is to use Package Configurations...
January 4, 2012 at 3:35 am
Can you not just get your network admin to grant permission for the SQL Server service account to write to the share?
John
December 30, 2011 at 4:39 am
Is this is a homework question? What have you tried so far? It really isn't clear what you require, in any case. Please also provide DDL in...
December 29, 2011 at 4:29 am
SQLAGENT.OUT is the log file for SQL Server Agent, and this is where you should start looking. What does it say in that file? If the file doesn't...
December 29, 2011 at 3:12 am
Or use the universal format yyyymmdd:
SET @date = '20111231'
This will work no matter what your local settings are.
John
December 28, 2011 at 8:24 am
kritika (12/28/2011)
to delete old backups also I need to create the script.
No you don't. You need to keep using maintenance plans. Tell whoever has asked you to roll...
December 28, 2011 at 3:08 am
But why make things difficult for yourself? This is what maintenance plans were designed for. Even if you don't use them for the backups themselves, you can still...
December 28, 2011 at 2:52 am
Have you considered using a maintenance plan to delete your old files? You can set it to remove all files older than a specified number of days.
John
December 28, 2011 at 2:26 am
alishaik001 (12/21/2011)
If my Table name "Employee" and field name is "FirstName"Suppose I have names like"
Abc
abc
ali
Ali
shaik
shAik
In these names I want only those names which are having small 'a' character;
Are...
December 21, 2011 at 9:59 am
That's right. (This is from memory.) If you use Take Offline to stop the service, the cluster knows you did it deliberately and so doesn't fail over. ...
December 16, 2011 at 8:41 am
Viewing 15 posts - 4,831 through 4,845 (of 7,191 total)