Viewing 15 posts - 9,676 through 9,690 (of 9,728 total)
Oh, right.
Try joining to Information_Schema.Columns on TableName and ColumnName. This should give you all the column information details.
How are you guys getting your code pasted into one line...
December 12, 2006 at 8:23 am
Or you could make it really simple.
Select
* from information_Schema.constraint_column_usage
Should work on both SQL 2000 and SQL 2005 and gives you table names as...
December 12, 2006 at 4:40 am
Of the logins you've listed, the only two native to SQL Server 2005 are the NT Authority \ Network Services and NT Authority \ System logins. Because they are native...
December 8, 2006 at 5:57 am
We use Erwin by Computer Associates. It's pretty nifty. Took me a little time to get used to it, but now I love the Reverse Engineering and Complete Compare tools. ...
December 8, 2006 at 5:46 am
If you're going for the MCDBA cert, may I offer a piece of advice?
There are (or were) two OS tests as part of the MCDBA. Windows 2000 Server & Professional. ...
December 8, 2006 at 5:43 am
Linda said:
Thanks, but that's my problem. I wouldn't be building the data warehouse becuase I don't have the time (being the only DBA), and the 'developers' are not familiar with...
December 8, 2006 at 4:49 am
I belive my boss wants something we can present to our VPs besides just basic reports. It's not just about the graphical "nifties". We have the problem of having too...
December 7, 2006 at 8:45 am
Too true, Rudy. I actually know an IT guy who is a genius at what he does, but hates doing IT work. It doesn't matter what job he does, who...
December 7, 2006 at 4:55 am
We're currently using SQL Server 2005 for our production DBs and SQL Server Reporting Services 2000 for our operational reports (haven't upgraded to SRS 2005 yet cause we're still trying...
December 6, 2006 at 8:21 am
Honestly, I haven't had to make a lot of comparisions. Not many moons ago, I was working in retail sales/customer service. When I got my first real IT job (a...
December 6, 2006 at 8:07 am
"Thank you"s are definitely one of the non-pay recognition factors that I count as an important thing. It's amazing how two little phrases ("thank you" and "please") transform a potentially dull and...
December 5, 2006 at 11:03 am
A boss who is reasonable in his/her demands and willing to stand up to the end users and the higher-ups for the employees under him.
A team that communicates and mostly gets...
December 5, 2006 at 5:59 am
Looks like this is a new forum. Perhaps created or requested by RedGate?? Maybe it's supposed to be internal to them.
Anyway, there's no moderator associated with it, so I think...
November 28, 2006 at 9:18 am
We've tried everything we can think of to deploy properly. Our problem is that we don't have separate servers for Dev/Test/QC. We've got the same server for all three with...
November 6, 2006 at 4:20 am
Lee,
Thanks for the response. I posted a reply on your thread as to what we finally figured out the problem was. We don't have a solid resolution yet that applies...
November 2, 2006 at 1:04 pm
Viewing 15 posts - 9,676 through 9,690 (of 9,728 total)