Viewing 15 posts - 5,281 through 5,295 (of 7,187 total)
Yes, sorry - I got a bit confused. Not with mirroring, but the way that a snapshot actually works. Modified pages are copied to the snapshot, but before...
June 17, 2011 at 3:40 am
What is a developer doing anywhere near your production database? If you're going to allow developers, or anyone else, to perform this sort of operation, then you need to...
June 17, 2011 at 3:16 am
Your best bet is to store dates as datetime (or just date) in your database. If you don't have any control over the structure of the database, you can...
June 17, 2011 at 2:45 am
mike.mcquillan (6/17/2011)
June 17, 2011 at 2:33 am
Yes. If a user doesn't have a Windows login, they'll need a SQL login instead, and you'd need to put the server in mixed authentication mode.
John
June 17, 2011 at 2:19 am
syscomments is provided for backwards compatibility only. Its replacement is called sys.sql_modules, and using it has the advantage that all text for any object is stored in one row....
June 15, 2011 at 9:11 am
If you put a USE xxxx statement at the very beginning of your script, you'll find that this doesn't happen.
John
June 15, 2011 at 6:57 am
Use a Merge Join transformation in your data flow.
John
June 15, 2011 at 6:53 am
Jayanth_Kurup (6/15/2011)
Whats wrong with using sp_help 'proc name' ?
It returns more than one result set so it's difficult to use programatically. If you compare the SQL behind the...
June 15, 2011 at 6:45 am
I always set the port number against TCP Port under IPAll. You can choose any number you like, provided that it doesn't conflict with a port that's already in...
June 15, 2011 at 4:35 am
You also need to back up the log just before you attempt the restore. If you can't do that, for example if any database files are missing, you can...
June 15, 2011 at 4:29 am
If you already have a package configuration in your package, you should be able to edit it. Click on the Edit button and change the configuration type to SQL...
June 15, 2011 at 4:27 am
Before you attempt any sort of restore, you should back up the transaction log. This gives you the option to restore to any point in time. It may...
June 15, 2011 at 4:17 am
Yes, we don't say "Yours truly", but there is such a word - it means much the same as "really", as opposed to "truthfully" which means "in truth".
Anyway, annoying features....
June 15, 2011 at 2:20 am
Jim
You can use temp tables, but beware of issues with their scope and life expectancy. I think I would just create a staging table in the database. You...
June 14, 2011 at 3:51 am
Viewing 15 posts - 5,281 through 5,295 (of 7,187 total)