Viewing 15 posts - 121 through 135 (of 498 total)
As stated above I also feel that the problem with putting Citrix and SQL on the same box is memory. Since Citrix essentially creates a new VM for each connection...
March 22, 2004 at 7:59 pm
I agree Hans! I've been running Term Services on my servers for the last 2 years in remote admin mode and will continue to do so for the unforseable future....
March 22, 2004 at 7:46 pm
If you look at the job's job history can you see what called it? It should say something like the following...
The job succeeded. The Job was invoked by Schedule 1 (Schedule...
March 22, 2004 at 7:31 pm
Bert,
that's great! I always forget about the ^ working in SQL server. BTW: You don't need to put this in a case statement!
IF EXISTS(select * from sysobjects where id =...
March 18, 2004 at 2:02 pm
I would double check the versions again. In fact I think I would copy the bcp.exe file from the machine it works to a different directory on the dev machine...
March 18, 2004 at 1:30 pm
The easiest way to create a format file is to use BCP. You can do this by the following command.
bcp dbname.dbo.tablename format -SMachineName -T -fFormatFileName.fmt
You can just hit the enter...
March 18, 2004 at 1:15 pm
Try adding an "ID" column with an identity to your table.
CREATE TABLE x
(ID INT IDENTITY(1,1)
, YourData varchar(255)
)
You should then be able to do your order by on the ID...
March 17, 2004 at 4:55 pm
I would probably go the route that Jarret suggested. Mainly because I want to make sure that I'm not doing something I shouldn't. This allows me to edit/double check each statement...
March 17, 2004 at 4:49 pm
Open Visual Studio .Net and create a new database project. Open Windows Explorer and drag in the folder and drop it on your project in the solution explorer pane. Then right...
March 17, 2004 at 4:38 pm
If you use a database project in Visual Studio .Net and save all your scripts in the project you can have Visual Studio make a dos command file for you to...
March 17, 2004 at 2:50 pm
Francisco,
What is the reasoning behind using the NOLOCK hint? Do you really need it?
BTW: You can have QA give you the elapsed time and cpu time for queries by...
March 17, 2004 at 2:15 pm
From BOL.
-b
Specifies that osql exits and returns a DOS ERRORLEVEL value when an error occurs. The value returned to the DOS ERRORLEVEL variable is 1 when the SQL Server error message...
March 4, 2004 at 11:51 am
As noeld said make sure to read the knowledge base article. Also follow the link to all the referenced articles as well. My guess is you are running Win2003 and...
March 2, 2004 at 12:18 pm
Take a look at OPENXML in Books Online...
From BOL:
DECLARE @idoc int
DECLARE @doc varchar(1000)
SET @doc ='
<ROOT>
<Customer CustomerID="VINET" ContactName="Paul Henriot">
<Order CustomerID="VINET" EmployeeID="5" OrderDate="1996-07-04T00:00:00">
<OrderDetail OrderID="10248" ProductID="11" Quantity="12"/>
<OrderDetail OrderID="10248" ProductID="42" Quantity="10"/>
...March 2, 2004 at 12:11 pm
Wow! Thanks for sharing that! I wish I had known that months ago!
March 2, 2004 at 12:04 pm
Viewing 15 posts - 121 through 135 (of 498 total)