Viewing 15 posts - 571 through 585 (of 628 total)
System Catalog for SQL 2000
http://msdn.microsoft.com/en-us/library/aa260604(SQL.80).aspx
syslogins
http://msdn.microsoft.com/en-us/library/aa260424(SQL.80).aspx
sysusers
http://msdn.microsoft.com/en-us/library/aa260592(SQL.80).aspx
SYSLOGINS will not tell you what databases they belong to just the server; for each database you'll have to search...
March 5, 2009 at 4:28 pm
Aye BEST thing Microsoft did .. who said they are money hogging big corporate jerks?
:P.
It's just like enterprise edition just can't use it as production 🙂
March 5, 2009 at 4:24 pm
Hmm I ran PSSDIAG on a system which was dedicated for one database so never needed to exclude other databases or filter.
I just looked at and the GUI interface doesn't...
March 5, 2009 at 4:20 pm
By SQLTrace you mean Server Side Trace?
Mohit.
March 5, 2009 at 4:11 pm
Naa they just starting to go white; my students at Kendo say I am finally catching up to them LOL. All good longest I don't lose em eheh.
March 5, 2009 at 4:08 pm
1.Yes should not be an issue.
2.0, you can look at SQL Server 2005 databases using SQL Server 2008 tools. But other I don't think is possible.
2.1, shouldn't I am...
March 5, 2009 at 3:47 pm
That trigger is def a good idea :). Another option you have is since the stored procedure is required in each database; why not add it to the MODEL...
March 5, 2009 at 3:41 pm
Another thing to note Raid 5 can be poor with on write intensive systems. CPU, Memory, SQL edition I think your good. I think you need to play...
March 5, 2009 at 3:37 pm
I found it did that for me when I patched the SQL Server 2005 RTM to SP2. It went from Mixed Authentication to WIndows only authentication. Did you...
March 5, 2009 at 3:34 pm
I think you can use SQL Profiler to see the number of rows returned. And log that to directly to the file, filtering on table in question might be...
March 5, 2009 at 3:32 pm
Heh Thanks Noel.
After I finish my Part 2 for Denormalization Article ..
I think I know what I am going to Rant about next maybe I'll just rant on me...
March 5, 2009 at 2:48 pm
Hey Carl,
Have you looked into SQLCMD? Maybe that can solve your issues, since it was shipped with SQL2K5. And I only use that I haven't...
March 5, 2009 at 2:35 pm
Luckily I haven't ran into replication much. Because as the only technology seems to be the defacto where I work is clustering or nothing heh. But for replication...
March 5, 2009 at 2:31 pm
An interesting topic on EF I was reading today ...
http://sqlskills.com/BLOGS/KIMBERLY/post/Seriously-are-you-kidding-me.aspx
In our organization as a DBA I don't get much say :(. Yaa it is sad, but we...
March 5, 2009 at 2:25 pm
You should be able to according to ..
http://msdn.microsoft.com/en-us/library/ms143393.aspx
Did you have look at ...
http://msdn.microsoft.com/en-us/library/ms144267.aspx
Confirm your edition and product information on current install:
SELECT ServerProperty('Version'), ServerProperty('ProductLevel'), ServerProperty('Edition')
Thanks.. Mohit.
March 5, 2009 at 2:18 pm
Viewing 15 posts - 571 through 585 (of 628 total)