Is there a way to customize alerts? There seems to be if I look at Type: SQL Server performance condition alert Object: SQL Server: User Settable Counter: Query Instance: User counter 1, User counter 2, etc. on up to User counter 10. How do I define User counter 1? Robert Marda
2002-03-15
18 reads
Help! Simple question about a bcp I am running, but got an error message. Sample bcp: BCP 'DBsta..vWeb_Tab_Date' out 'StatusReportDate.txt' -c -S'Mickey' -U'DonaldDuck' -P'Daisy' DBsta = DB name vWeb_Tab_Date = View name StatusReportDate.txt = text file Mickey = server for test purposes donalduck = test user daisy = test password What it does is: It […]
2002-03-08
7 reads
We have SQL server 7 installed on a server. We rename the server. Do we have to re-register SQL server or does it automatically use the new name? Any help is appreciated.
2002-03-04
6 reads
Hello, PLEASE GIVE ME A SOLUTION IM AM USING SQLSERVER 7.0 i have a table which contains the following fields namely refererid,code,name this is just like a referral program a guy can refer 3 guys under him i.e, 3 is referring three guys namely 4 5 8 similarly 4 is referring 9 10 and 11 […]
2002-02-28
2 reads
Andy read this book recently and gave it a great review. Even though it's not a SQL book! Seriously, take a look at the review. It's a good book that is fun to read.
2002-02-26
3,261 reads
I have a simple dts package, taking a textfile into SQL table, then outputting the results to Foxpro table for remote distrabution the problem is that the original txt file name changes every day FILEMMDDYY, and the foxpro table should be the same FOXMMDDYY can this be done without intervention as i would like it […]
2002-02-22
I am running Sql 2000 in Active/Active mode. I need to change the sa password. Is that as simple as going into Enterprise Mgr and changing the password like any other user and do this in both instances of SQL? Thanks, Tracy
2002-02-21
1 reads
I am converting an Access database into SQL, and am totally stuck on some queries that required the user to input criteria in the Access version. I know I need to write a user defined function for this, but not sure how. Below is one of the simple Access queries that I need to convert […]
2002-02-18
I have a CSV file of 105k records that when I used DTS, BCP or BULK INSERT the data does not import correctly. The file is formated like ,,,"text",,"text" and so on.. when building a DTS Package I select the row as LF and the Text Deliminator as " and I immediately get a message […]
2002-02-13
4 reads
Mindy explores the metadata stored in SQL 2000 to show you how to produce a simple and useful data dictionary!
2007-10-02 (first published: 2002-02-11)
36,116 reads
By Steve Jones
Here are the slides from my talk today: CI in Azure DevOps If you...
By Steve Jones
I got asked this question recently: I constantly see PostgreSQL on Microsoft slides, email,...
By Steve Jones
hickering – n. the habit of falling hard for whatever pretty new acquaintance happens...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers