Viewing 15 posts - 1,711 through 1,725 (of 5,356 total)
This and many more informations on dynamic sql you can find here:
http://www.sommarskog.se/dynamic_sql.html
November 25, 2004 at 12:51 am
Hey, as a non-native speaker, I have the advantage to be able to blame it on the language ![]()
November 24, 2004 at 7:59 am
... another log file of similarly restricted size
See my reply above.
November 24, 2004 at 7:56 am
I'm refering to this what you can find in BOL under striping. I guess that's what you call split.
November 24, 2004 at 7:54 am
See. if this helps:
http://www.sommarskog.se/error-handling-II.html
http://www.sommarskog.se/error-handling-I.html
November 24, 2004 at 6:02 am
Why? It isn't important after all, since you can't adress it anyway.
November 24, 2004 at 4:14 am
Create a job that executes the SP. You can schedule this as you need.
November 24, 2004 at 3:32 am
This will give you the uptime in days:
SELECT
CAST((CAST(DATEDIFF(ss, login_time, GETDATE()) AS DECIMAL(9,2)) / 86400) AS DECIMAL(6,2))
FROM
master..sysprocesses WHERE spid = 1
or, since tempdb is always recreated when SQL Server startes...
November 24, 2004 at 1:58 am
Hm, might be my language barrier: Is the question about split the log file or strip the log file?
![]()
November 24, 2004 at 1:41 am
Unfortunately, your browser issues is not firefox specific. There are some thing here that do not work like someone would expect them to. ![]()
But to...
November 24, 2004 at 1:14 am
You might want to use the search functionality here on this site. Or was it on some other site?
However, what is your problem? Importing a URL into a VARCHAR column...
November 24, 2004 at 1:05 am
...and in case you get into some issues, you know where to find help.
![]()
November 24, 2004 at 12:53 am
Not completely sure, if I understand you correctly, but in SQL Server 2000 you can have user-defined data types, which to a certain degree might do what you want. You...
November 24, 2004 at 12:48 am
Yes, removing the "with allow_dup_row"... should do it. SQL Server will internally add the uniqueifier when necessary to mark a single row as unique.
November 24, 2004 at 12:38 am
Okay, while this is technically correct, one shouldn't make this frequently. At least, one should make sure to have a current backup.
![]()
November 23, 2004 at 2:43 pm
Viewing 15 posts - 1,711 through 1,725 (of 5,356 total)