Viewing 15 posts - 541 through 555 (of 824 total)
Well, it's not like I spent the entire time doing nothing but researching XML... I started out hearing about XML and its wonerous benefits. Unfortunately nothing I read dealt with...
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
April 22, 2005 at 6:03 pm
I assume that they are using 2000, however, with 2005 right around the corner, it is prudent to think about it and plan accordingly.
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
April 22, 2005 at 5:29 pm
Well, at least you have (hopefully) have an understanding that your actions can have huge consequenses, and will exercise appropriate caution.
Unfortunately, this is a familiar situation for SQL Server. ...
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
April 22, 2005 at 5:20 pm
...and will not work with SQL 2005...
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
April 22, 2005 at 7:26 am
This depends on many factors. How "Real-time" do the reports need to be? What is the typical usage pattern for your transaction processing? 200000 records a day doesn't really tell...
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
April 21, 2005 at 2:26 pm
In order for them to create objects owned by dbo they need to be in the db_owners group and prefix the names of all objects with dbo.
DTS won't change ownership...
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
April 21, 2005 at 2:10 pm
If the application has hardcoded connection strings, then you're out of luck...
Fortunately, most apps (at least if they are written by competent developers) make use of some sort of dynamic...
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
April 21, 2005 at 2:01 pm
Someone, maybe even you, changed permissions for your login. Do you have anyone else who administers, or who has access to that server? If the default setup hasn't changed, anyone...
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
April 21, 2005 at 1:11 pm
If the data types are not the same you can't declare a fk constraint, so he can't have a fk on the table.
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
April 21, 2005 at 1:07 pm
If the ISNUMERIC test reports that all the data is, in fact, numeric, you should be able to just issue an alter statement in Query Analyzer, like the following:
ALTER TABLE TableName
ALTER COLUMN...
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
April 21, 2005 at 12:21 pm
It might be a DNS issue. Can you PING the server using its name?
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
April 21, 2005 at 12:09 pm
sp_attach_single_file_db
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
April 21, 2005 at 10:22 am
No, SQL Server 2000 does not enforce any kind of policy on SQL account passwords. I didn't have the pleasure of dealing with an actual audit, but our compliance dept...
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
April 21, 2005 at 10:18 am
Are you the interviewer or the interviewee?
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
April 18, 2005 at 9:59 am
Glad I could help. Just for future reference, Oracle does not automatically keep statistics up to date (unless they have changed that in 10...) So if you have large loads...
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
April 13, 2005 at 8:36 am
Viewing 15 posts - 541 through 555 (of 824 total)