Viewing 15 posts - 631 through 645 (of 1,884 total)
Agree with JB. INSTEAD OF Triggers are the first that I would use for the Hard Way and I have seen code using them. They can not be implemented in...
August 17, 2006 at 9:12 am
Sean,
You may include your previous experience on the separate line as "consulting" for for your current employer, which well describes your contributions. I would certainly get a certification, it really...
August 3, 2006 at 2:57 pm
Daniel,
It is not an easy task unless you define a lot of rules in a kind of a dictionary or table. While it is easy to replace spaces with |...
August 2, 2006 at 3:26 pm
Why do you need to Update Statistics on msdb?
August 2, 2006 at 2:11 pm
Brian,
CREATE STATISTICS topic in BOL says:
"Computed columns can be specified only if the ARITHABORT and QUOTED_IDENTIFIER database options are set to ON. "
http://msdn2.microsoft.com/en-us/library/ms188038.aspx
August 2, 2006 at 11:42 am
One thing that may fail in this approach is if you have local accounts as logins to SQL Server then when you replace the server and re-create this new local...
August 1, 2006 at 10:56 am
I probably did not have my cofee yet. I am running a query from Management Studio 2005 towards 2000 Northwind database without grouping and I looked up that EmployeeID =...
July 31, 2006 at 9:21 am
I would try if you can create an ODBC source from your workstation using named Pipes. It will show you if you can connect at all. Your error message talks...
July 27, 2006 at 11:14 am
It is easier to ask the server sysadmins to submit you the list of logging modes then to give you the access to their servers to run...
July 25, 2006 at 2:45 pm
I would not go as far as that. Make sure the recovery Model is Simple for TempDB. There are some other recommendations by Microsoft books:
- You may want to put...
July 25, 2006 at 2:39 pm
Brian,
1. In the companies where the responsibilities are split to the point that server admins don't have the database access, then in these companies it is very unlikely that a DBA will...
July 25, 2006 at 2:22 pm
C:\Program Files\Microsoft SQL Server\90\SDK\Assemblies\en\Microsoft.SqlServer.Smo.xml
This config file contains settings for the target servers (multi-server administration) if you are asking about enlisted servers. You have to search this doc for the keyword...
July 24, 2006 at 10:18 am
They will be able to get access to the secure data anyway:
1. By Changing the password for SQL Server Startup account. By Default (and by the question this is the default...
July 24, 2006 at 9:24 am
The Profiler traces can show Start Time and End Time for statements and batches
July 20, 2006 at 3:50 pm
Alex,
I would not delete the folder. Because you have SQL Server pointing to this folder.
I read the message again. It says "The specified object cannot be found". It is just...
July 20, 2006 at 3:47 pm
Viewing 15 posts - 631 through 645 (of 1,884 total)