RE: Error 7399 OLE DB provider microsoft.jet......
Permissions are fine... I just don't understand how under one SQL server I can access the Link server and through a different server I can't.
2004-02-11
1 reads
Dynamic SQL
Active\Active SQL server cluster
Hello All, I'm a bit confused on how the failover processes works on a SQL server 2000 two node active/active cluster in terms of handling system databases. Given the following You have 2 node active/active cluster NodeA & NodeB and If I'm not mistaken a two node active\active cluster will have 2 instances running i.e NodeA will have a default […]
2004-01-20
2 reads
RE: How to import a .sql file with DTS
Replace filename with the name of the .sql file, eg if the file you want to execute is called test.sql in the temp directory of your c: drive then would use isql /S servername /U username /P password -d databasename -b /m-1 /i c:\temp\test.sql Remember to change the other parameters as well.
2003-11-19
1 reads
RE: Integration with Dot.Net, UDT's
We do use UDT either. I think it is better to use strong Entity/Attribute data modeling software and let the foreign key migration enforce the data conformity. For non-keys we use LOGICAL ONLY UDT but translate them to standard data types in the physical model. We use ERwin. It is a little pricey but I […]
2003-08-08
RE: TIMESTAMP WITH LOCAL TIME ZONE
What's a "TIME ZONE" datatype? I mean, in what DBMS is it valid? Cheers, - Mark
2003-08-06
RE: Can't see datbase in Enterprise manager
I've never heard of a change of password having such an effect. Your Windows account didn't change at all did it? Eg. Account deleted and then added back in with the same name? Or maybe account moved to another domain? Cheers, - Mark
2003-08-02
RE: need help with COUNT
Here's one problem with your script: and Fname LIKE '%%%' First, this selects ALL data from Fname. Second, it overuses the %. Are you trying to get everything from Fname? If so, delete that line. Are you trying to get Fname where there are only three characters? If so, change the theree %'s to three […]
2003-07-31
RE: Single User Bug????
Excuse me for buttin in, but: "However, if it can change to single-user, but someone else logs in before the DBCC command starts, then the job fails, and the database does not change back from single-user mode." How could somebody else log in after the DB was switched to single-user? Mvg, MvG.
2003-07-31
RE: Another query that takes too long
One thing that may speed it up is the following: When possible, use isnull rather than the case statement. According to the execution plan, it is twice as fast. ie. replace this: CASE WHEN @Country IS NOT NULL THEN @Country ELSE Country END with: isnull(@Country,Country) additionally: You may want to put your top 3000 select […]
2003-07-17
RE: poor Question of the day 7_13_2003
quote: Now, your "correct" answer says that a login is all that's required, and furthermore it indisputedly implies that database permissions are *not* required (since you say that's *not* the right answer). I think this is a bit of semantics and here's why: - I can assign anyone a login within SQL Server. - I […]
2003-07-14
Blogs
Enabling an Index: #SQLNewBlogger
By Steve Jones
I don’t do a lot of work with disabled index, but I learned how...
Back to Boston for SQL Saturday
By Steve Jones
I’m leaving again tomorrow for a trip. This time I head back to Boston...
T-SQL Tuesday #179: What’s In Your Data Detective Toolkit?
By Tim Mitchell
Most of us who work with data have, at least a few times, been...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers