Viewing 15 posts - 9,661 through 9,675 (of 9,720 total)
YOu'd have to talk to the hardware guys to verify everything, but you absolutely CAN take one server and hook it up to a SAN after another server crashes. The...
December 22, 2006 at 11:02 am
SQLBill? Tek-Tips SQLBill? If so, this is Catadmin. Hi! @=)
NB, SQLBill is correct. You cannot backup SQL Server on a network share. It has to be backed up to a...
December 22, 2006 at 5:07 am
We've never had any problems with doing traditional SQL backups on our SANs. We just set our maintenance plans to delete backups after X number of days and Transaction logs...
December 22, 2006 at 5:04 am
Are you trying to enter your server name as opposed to creating a Mail connection object? Or are you just needing the server name as the "FROM" part?
If the later,...
December 22, 2006 at 5:01 am
I'd be interested in hearing this too. Please post your solution.
Thanks, @=)
December 22, 2006 at 4:58 am
Ah. Thanks, Brian. I'll try that.
Select cu.*, c.Data_Type, c.Numeric_Precision, c.Column_Default
from information_schema.Constraint_Column_Usage cu
join information_Schema.Columns c
on cu.Table_Name = c.Table_Name
and cu.Column_Name = c.Column_Name
WHOOHOO! It works. Thanks again. And, this is the query I'd...
December 13, 2006 at 4:30 am
I'm trying to. And it always double spaces it even though SSMS has things single spaced.
December 12, 2006 at 12:07 pm
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
Viewing 15 posts - 9,661 through 9,675 (of 9,720 total)