Viewing 15 posts - 1,846 through 1,860 (of 2,636 total)
SQL Server security is based on logins, not programs. To prevent unauthorized access to databases, no matter what program is used, restrict the access to only those logins that need...
October 13, 2006 at 10:58 am
The easiest thing to do is save the packages as VB file, edit it and search for the string. I believe that I've seen something in the script section of...
October 12, 2006 at 4:59 pm
You should have been asked to set a password for SA when you installed SQL 2000. The password set for it in SQL 2005 is irrelevant since SQL Server logins,...
October 6, 2006 at 9:19 am
As Steve suggested, script them out of Enterprise Manger and execute the script in Query Analyzer on the destination server. It should only take a few minutes.
Greg
October 5, 2006 at 11:49 am
32. See "Maximum Capacity Specifications" in BOL.
Greg
October 5, 2006 at 11:45 am
There's no native SQL Server tool for this. We use ApexSQL Diff, and there are others that aren't very expensive.
Greg
October 5, 2006 at 11:41 am
Gavin,
Your image of the error message doesn't display. Could you post the text of the message?
Thanks,
Greg
October 4, 2006 at 5:30 pm
You could run a trace from Sunday afternoon to Monday morning and see what is running on the server during that time. Maybe there's something that you don't know about yet.
Greg
October 4, 2006 at 5:26 pm
Enterprise Manager uses the system stored procedures in msdb. I verified this by starting a Profiler trace and using Enterprise Manager to expand Management -> SQL Server Agent -> Jobs. Then...
October 4, 2006 at 5:20 pm
Do you want the user to be able to see the properties of every job or just see the list of jobs? Depending on what exactly you want to allow,...
October 4, 2006 at 12:31 pm
I would expect the differential backup size to grow as changes are made in the database. You don't mention the amount of data changing activity that occurs in the database...
October 4, 2006 at 12:17 pm
I recently had to do this and used this method:
1. In Enterprise Manager, right-click on a database object e.g. a table or view and select 'Generate SQL Scripts'
2. On the...
October 4, 2006 at 11:49 am
Not unless you had a Profiler trace or some other auditing process running that was looking for that event.
Greg
October 4, 2006 at 11:37 am
Monika,
Since you posted in the DTS forum, I assume you want info about how to get the data from the csv file into SQL Server.
I would use a Data...
October 4, 2006 at 10:16 am
Cool! Glad to help.
Greg
October 3, 2006 at 5:23 pm
Viewing 15 posts - 1,846 through 1,860 (of 2,636 total)