Viewing 15 topics - 281,221 through 281,235 (of 284,037 total)
Topics
Started by
Posts
Last post
Pls can anybody suggest me which data type is best suitable for primary key, joins Numeric or Varch…
3 replies
I saw the script on this website that counts the number of rows in a table. I modified it to return…
6 replies
Is there an equivalent to the Oracle 'minus' in T-SQL? Minus returns all the rows in one select st…
2 replies
I would like to have an email sent every Friday and Monday in SQL 7.0 with results from a query. H…
5 replies
Setting: Sql 7 server (no SP due to conflict with PowerBuilder), Windows NT (SP6) The server was wo…
4 replies
On a Win2000 server, I created a maintenance plan on an SQLServer 7.0 to backup a database but it w…
5 replies
Hello, I need to create a set of the data files from the views in the sql server2000 and send this …
3 replies
It's the end of the day and I've just discovered that a few of my stored procedures recompile every…
1 replies
I renamed some ID's in a table. Then I dropped the table. The id was used in another table with a…
11 replies
I have a server that has a maintenance plan to run backups. The agent service is running however t…
4 replies
Does anyone know how to programatically set the recovery level to simple on a database? Thanks, Neil
2 replies
If I create a function as a user with sa_role, like so: CREATE FUNCTION fPlusOne (@Input1 int) RETU…
3 replies
Hi, I am currently loading our datawarehouse via stored procedures that "push" data from our stagin…
8 replies
I'm trying to create an Extract from source data that is too complex to be created as a view (also …
3 replies
My co-worker is having a problem with an application he is writing. He needs to input the new Euro …
4 replies
Viewing 15 topics - 281,221 through 281,235 (of 284,037 total)