Viewing 15 posts - 31 through 45 (of 2,635 total)
I recommend "Drive", which should have been nominated, and "Midnight in Paris".
February 24, 2012 at 10:16 am
Well, you can't get info about database roles and object permissions just from Master. That data is stored in each database.
Have you checked the script section here at SSC?...
November 30, 2011 at 9:33 am
IceDread (11/30/2011)
Maybe this is very individual as well as different per country. I have never in my whole life read emails while on vacation.
Same here. I've always been able...
November 30, 2011 at 8:59 am
You could try taking a backup of the SQL 2000 database and restoring it in a SQL 2008 instance, then changing the compatibility level to 100. Then you should...
November 29, 2011 at 9:30 am
I think you're mixing apples and oranges terms. A database backup is performed either in Enterprise Manager by selecting All Tasks -> Backup Database or by using a BACKUP...
November 29, 2011 at 9:02 am
In IT settings, I'm a DBA.
Outside of work, I say I work with databases. That usually heads off any questions about what's wrong with someone's computer.
Another uncomfortable question for...
November 18, 2011 at 11:37 am
It's too bad nobody referenced BOL for this quote:
"If a SELECT is used in an application or script that has logic dependent on the number of columns in the...
November 14, 2011 at 12:07 pm
I didn't start working in IT until my mid-20s, so I had a few jobs before and learned something from each.
I worked in a service station in my...
November 2, 2011 at 10:01 am
You can't restore msdb between versions. Your best bet is to script jobs, upgrading SSIS packages in BIDS, and recreating maintenance plans.
October 26, 2011 at 10:01 am
john.barry-1031177 (10/21/2011)[hrDont let DTS stop you from migrating/updating to 2005. DTS works fine in 2005. We migrated all of our 2000 databases to 2005 instances two years ago,...
October 21, 2011 at 9:05 am
This is usually a permissions problem. Does the N account that SQL Agent runs as have the required file permissions on the FTP location?
September 16, 2011 at 9:02 am
When I worked with Oracle, I used logical backups, created by the Export utility, to move data between databases without having to do a physical backup and restore. It...
September 8, 2011 at 9:57 am
I commute by bicycle most of the time so I park at the bike rack just inside the entrance. I do tend to put my bike at the end...
September 1, 2011 at 8:50 am
Native log shipping was only available in Enterprise Edition of SQL 2000. i've seen some home grown log shipping solutions for Standard Edition. A Google search should find...
August 30, 2011 at 10:02 am
This finds a string in functions, views, and stored procedures.
select distinct o.name, o.type_desc from sys.objects o
where OBJECT_DEFINITION(o.object_id) like '%searchstring%'
order by o.name
August 17, 2011 at 4:02 pm
Viewing 15 posts - 31 through 45 (of 2,635 total)