Viewing 15 posts - 571 through 585 (of 629 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 sysusers to find the user list...
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
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 🙂
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
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...
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
March 5, 2009 at 4:20 pm
By SQLTrace you mean Server Side Trace?
Mohit.
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
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.
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
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...
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
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...
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
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...
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
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...
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
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...
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
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...
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
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...
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
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...
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
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 ended up...
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
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.
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
March 5, 2009 at 2:18 pm
Viewing 15 posts - 571 through 585 (of 629 total)