Viewing 15 topics - 269,356 through 269,370 (of 283,942 total)
Topics
Started by
Posts
Last post
Hi All, I encountered the following problem: The company I work for has a database installed with a…
7 replies
SQL on a linked database loses its 'where' clause when passed to the remote database. This results …
2 replies
Hi All, I'm a fan of identity data type, I always use identity as a primary key in all my tables. H…
11 replies
Is it possible to find the WAN IP Address from T-SQL? I have only been able to get internal IP Add…
2 replies
Hi, I'm attempting to build a cursor in a stored procedure. HOwever when I execute the string it re…
1 replies
Is it possible to check syntax of SQL pragmatically before the execution? Of course I can wrap the …
2 replies
We have some template stored procedure stored in text files. Is there an easy way to stuff the fil…
3 replies
I have a table, which contains address information, have non-clustered index on phone no, search o…
1 replies
I'm having enormous difficulty getting xp_sendmail to work with the @query parameter. Need some he…
25 replies
I've got a good DTS working model for the ODS and tables are refreshed each night from production (…
3 replies
When I drop a table,create another table and fill it with data, the resultset showed in a view is t…
5 replies
Will a stored procedure run faster as a Job under Sql Agent then it will in QA run on the server? F…
1 replies
Can anyone tell me what the maximum length of a T-SQL statement SQL Server 7 Or 2000 will support? …
2 replies
Hi All, I have a requirement where some users needed UPDATE privileges for a specific time during t…
6 replies
Can anyone give a hint as to how I can run/execute a series of stored procedures from within a DTS …
8 replies
Viewing 15 topics - 269,356 through 269,370 (of 283,942 total)