Viewing 15 posts - 37,051 through 37,065 (of 39,720 total)
September 20, 2002 at 10:39 am
If I understand this, you have an identity column (EmpID or something) in a table that is a PK. You need to change these values.
What you might want to do...
September 20, 2002 at 10:34 am
rowcount or TOP will limit results, but this may not be what you need.
Steve Jones
September 19, 2002 at 12:26 pm
profiler shoudl show you what is passed to the server. That will tell you if it is sending the where.
For Perf mon, there is a great e-book for sale here...
September 19, 2002 at 12:21 pm
Setup a trigger to rtrim() the fields. But for CHAR, there will always be blanks.
September 19, 2002 at 11:15 am
It is possible. I'd use a .cmd file and make a shortcut to that. Also, better (IMHO) to use Windows Auth with this.
Steve Jones
September 19, 2002 at 11:02 am
Run some performance monitoring as well.
Steve Jones
September 19, 2002 at 10:56 am
Unfortunately, I haven't been able to get the extended properties in a query. The query above will give some stuff, but I think you will need a cursor and loop...
September 19, 2002 at 10:50 am
DST might be the easiest. Or use multiple steps. One to run the sproc. You might need to use xp_cmdshell running isql to create the ouptu file.
For the zipping, use...
September 18, 2002 at 2:43 pm
September 18, 2002 at 2:40 pm
not really. Can you post some DDL and sample data?
Steve Jones
September 18, 2002 at 2:38 pm
You can limit profiler to queries with some long time (> 2 minutes or something) which will make it easier to track them down.
Steve Jones
September 18, 2002 at 2:34 pm
The code is more a client issue. Add a binary column to the table and insert the word document into that. Sending it to the stored procedure will take a...
September 18, 2002 at 1:28 pm
Viewing 15 posts - 37,051 through 37,065 (of 39,720 total)