Viewing 15 posts - 3,211 through 3,225 (of 7,191 total)
You need the position of the final backslash and the final underscore and to take everything between the two. You can get the position by reversing the string and...
April 7, 2015 at 5:06 am
I try to make packages self-documenting, with plenty of annotations, and tasks named to be descriptive of what they do. If you number your tasks as well, you can...
March 31, 2015 at 9:19 am
You can either pull in a directory listing for the folder that contains the backup and use that to determine the most recent, or you can query msdb on Server...
March 31, 2015 at 7:57 am
I think it's so that the CTE definition doesn't get mistaken for an index hint or something similar.
John
March 31, 2015 at 7:54 am
If I had thousands of files, I think I'd prefer to use xp_cmdshell to run dir /b and pull all the file names into the staging table in one go....
March 31, 2015 at 7:38 am
I didn't even know you could do that. Can I ask why you want to, please? I can't think of any problems it would cause, since your applications...
March 27, 2015 at 10:22 am
Yes, expand the files manually if you can, at a time of low activity. I would recommend that you leave auto-grow enabled, in case of any unexpected rapid growth....
March 27, 2015 at 9:41 am
Here's one example[/url]. There are many more out there if you search for them. You may find it helps to add other columns to the table to suit...
March 27, 2015 at 9:33 am
You could do some fancy date arithmetic, but it's probably easier just to create a calendar table and join to that where the day datepart is 1.
John
March 27, 2015 at 9:22 am
Yes, you can use SSIS, bcp or BULK INSERT, whichever works best for you. There are other cruder ways of doing it as well, such as building a set...
March 27, 2015 at 3:44 am
This is why I rarely use the GUI for stuff like this - you never know what it's going to do behind the scenes. Use sp_addrole to create the...
March 25, 2015 at 9:19 am
Yes, or he could tell us why he is "unable to log in via Windows authentication". I'd be surprised if he's tried exactly what I suggested in my first...
March 25, 2015 at 6:35 am
Vijay
Yes, log on to the server as an administrator, start SQL Server in single user mode, connect locally using Windows authentication, change the sa password, and restart SQL Server.
John
March 25, 2015 at 3:14 am
Kathy
I would categorise it as a user database (although I don't think it's all that important which pigeon-hole you choose to put it in). It can't do any harm...
March 23, 2015 at 10:44 am
Viewing 15 posts - 3,211 through 3,225 (of 7,191 total)