RE: SQL Newie needs help
Thanks frank. I do have Enterprise Manager so I will look for tutorial with that. I will also look for tutorials for OLEDB.
2003-07-13
1 reads
Dynamic SQL
2003-07-11
1 reads
RE: Error 927 Database test cannot be opened
hi, just do the restore again with force restore over existing database, rather then removing it forst Paul
2003-07-11
1 reads
2003-07-10
1 reads
RE: help
No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!
2003-07-07
RE: sql server log
Hi, i've had a similar problem in the past. Too many successful login messages in the errorlog. What I did was use the NT command FINDSTR to ignore any lines that contain the words "login succesful". and redirect the output to a file which is then a lot easier to read. I set up a […]
2003-07-03
RE: Rights Accross Databases
You have to have cross db ownership chaining enabled and the user has to exist in the other db as well. SP3 would have broken this if you didn't check the chaining checkbox during the install. Andy http://qa.sqlservercentral.com/columnists/awarren/
2003-07-01
1 reads
RE: copying DTS packages from one server to another
To copy all DTS Packages, there is an SQL Server add on tool(DTSBackup), that you can use to script all DTS's then copy over theses script and run them on the target server. Remeber all DTS are stored in msdb. Thanks
2003-06-26
1 reads
RE: DTS package won't run as job
Which account did you use to run DTS package from server console? Is it same as the SQL Server Agent account? Who is the job owner?
2003-06-25
1 reads
RE: New SQL2K Running REALLY SLOW
Hi there Sounds like it could be an ODBC log. You might this link useful: http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/Q268/5/91.ASP&NoWebContent=1 If that doesn't help, my first step when investigating performance problems is to check memory usage. Try using to the Windows Performance monitor to check the sql server Buffer Cache Hit Ratio - Microsoft recommend that this should be […]
2003-06-13
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