Viewing 15 posts - 5,281 through 5,295 (of 7,191 total)
Bhuvnesh
Looks like you've left a "=" or a "LIKE" or some such out of your WHERE clause.
John
June 20, 2011 at 4:41 am
Steve
You just need to use a PARTITION BY clause in your ROW_NUMBER function.
John
June 17, 2011 at 8:47 am
Jordon
One of the problems of using the GUI is that it throws up unexpected things like this. Try scripting the view out and editing the actual T-SQL.
John
June 17, 2011 at 8:42 am
Brandie, a full backup doesn't break the log chain, although a lost or corrupted log backup certainly would.
John
June 17, 2011 at 4:37 am
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
Viewing 15 posts - 5,281 through 5,295 (of 7,191 total)