Viewing 15 posts - 35,041 through 35,055 (of 39,723 total)
We are looking at a similar issue in migrating two AD forests to a 3rd new forest. Fortunately the network guys have prepopulated all accounts in the new domain/forest.
the fix...
April 2, 2004 at 10:39 am
Wow, that surely isn't about SQL. ![]()
I know Andy has an IP phone at home, but not sure if he knows. He's a...
April 2, 2004 at 10:33 am
The above suggestion is correct. ANY user, including yourself that has a session open to that db has a shared lock on the db.
April 2, 2004 at 10:31 am
Not in your area, but there are a few online places, like IMG University (http://www.imguniversity.com/WebUPublic/default.asp). I took a remote class and it was ok.
http://www.sqlservercentral.com/columnists/sjones/imguniversity_olap.asp
April 2, 2004 at 10:29 am
Suggestions above are good. Be sure all connection options are the same. I'd also be wary of dbcc freeprocache as it wipes all query plans out and could cause performance...
April 2, 2004 at 10:28 am
If you always drop/create instead of alter, then you can use sysobjects.crdate to find changes. RedGAte and others have tools to give you a list of differences in objects between...
April 2, 2004 at 10:26 am
You will always convert to string for the exec() statement. However, I think for other values, you should be able to determine the field type from information_schema.columns and then set...
April 2, 2004 at 10:24 am
sp_helpdb will also erturn this, but you have to parse the info.
April 2, 2004 at 10:15 am
are there any routers/firewalls in the way? Be sure that you can get to UDP 1434 for the remote machine to "find" the instance port. Alternatively you can set teh...
April 2, 2004 at 10:03 am
Great introductory article to looking at performance. The suggestions above are good, but most code might be improved if each developer took a few minutes to run these and see...
April 2, 2004 at 9:50 am
If this actually occurs, it's a bug. Call PSS.
April 1, 2004 at 11:39 am
I don't believe Windows 2000 can do this. Windows 2003 is supposed to be able to tell which are physical and which are logical, but I doubt that SQL Server...
April 1, 2004 at 11:04 am
If you can't get this, you can uninstall, reinstall and attach your dbs. You'd lose your pwds and logins, but no data.
April 1, 2004 at 9:48 am
As far as this system is concerned, it's a DW backend for a Microstrategy backend, so many of the peaks are not tunable. End suers pick a few things and...
March 30, 2004 at 4:03 pm
There are no arrays in TSQL, however since the value that is returned is from a field and based on anothre field value, I'd suspect that a join is what...
March 30, 2004 at 3:31 pm
Viewing 15 posts - 35,041 through 35,055 (of 39,723 total)