Using xp_cmdshell in WindowsMe
I'm using the comand xp_cmdshell in Windows 98 and it´s works fine, but whem I tried to use the same comand in Windows Me they return ok to me but didn´t give any answer. Who I can fix it?
2001-10-09
administration
identity columns - keeping values in sync
Hi all A programmer recently asked me if I can "reset" an identity column on a specific table to start from a specific value. The case is where we have a reference data table with values: 0 1 2 3 if we insert a new row SQLServer gives us 8 instead on 4 as previous […]
2001-10-08
1 reads
Job Error Messaging
I was wondering if anyone new of any tables in 7.0 used for job messaging that are not documented on the system table map.
2001-10-08
3 reads
SQL Server 2000 Useful Undocumented Stored Procedures
In this article, Alexander Chigrik looks at some useful undocumented stored procedures that shipped with SQL Server 2000.
2008-10-17 (first published: 2001-10-08)
30,187 reads
Printing to an output file
I have a DTS Package with an ActiveX Script. I want the ActiveX Script to print to the file I re-direct the package execution to. Is there an easy way to do this? I have tried this: If cmdNew.Parameters("@RUNNING") = True Then Print "The " & DTSGlobalVariables("gvsInterfaceName").Value & " is currently running. Failing package!" Main […]
2001-10-05
1 reads
How To Send More than 1000 email in asp at a time
I want to send 10000 email at a time from asp for that i had used cdonts object but after sending 1000 email i am getting error please tell me how to solve the problem vijay verma
2001-10-04
2 reads
THE LAST DAY OF MONTH
Do you have any idea how to find the last day of the previous month? The select I have below works, however I am more than sure that there shoud be another less complex way to do it. select datediff(day, convert(varchar(4), year(getdate())) + '/' + convert(varchar(25),(month(getdate()) -1)) + '/' + convert(varchar(25),day(getdate())) , convert(varchar(4), year(getdate())) + […]
2001-10-03
Remote backups
Hi all, How do I take a SQL backup from EM to a remote machine? Is it enough if we give the remote server's name and shared folder? Lile \\server1\shared1\sqlbackup? Kindly clarify Parasu Raman
2001-10-03
2 reads
"Unable to connect to Server" error
Hi, We are running into the following problem after installing the SQL Server 6.5. We have installed SQL Server 6.5 in the test machine(031265), with local system account being used for login. The server NT031265APPLGE is running (shows green light). The services - MSSQLServer, SNMP, SQLExecutive - are running. But, when we try to register […]
2001-10-02
running sp in a linked server environment.
Please help. My brain seems to be blocked today. I am trying to run a system stored proceedure from a link server but it is not working. EG running sp_help or sp_who from my local machine on all or one of my linked server. Somebody to my rescue. Sonn
2001-10-02
2 reads
Blogs
Step Up Your Data Game: Learn Advanced SQL Techniques for Analysis
In the modern data-centric landscape, SQL stands out as the dominant tool. It's essential...
SQL Saturday Boston 2024 Slides
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
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