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...
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
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....
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
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...
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
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 =...
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
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...
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
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...
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
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...
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
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...
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
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...
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
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...
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
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...
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
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...
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
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...
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
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"/>
...
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
March 2, 2004 at 12:11 pm
Wow! Thanks for sharing that! I wish I had known that months ago!
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
March 2, 2004 at 12:04 pm
Viewing 15 posts - 121 through 135 (of 498 total)