Viewing 15 posts - 37,036 through 37,050 (of 39,818 total)
Need some type of NT/AD scripting to get this info. Not directly in SQL. Could use SP_OACreateObject to instantiate one of the group objects and query it. Not pretty.
Maybe Brian...
October 22, 2002 at 1:26 pm
Need to query the len() of the varchar columns. Other data types have their precision listed in select * from information_schema.columns. Have to write something to sum up the values.
Steve...
October 22, 2002 at 10:18 am
Apologies for not dropping this sooner, but as someone else mentioned, they hadn't seen it either. I just heard about it last week.
We welcome submissions from users if you see...
October 21, 2002 at 10:34 am
Haven't had issues myself. If I get the debugger running, usually rights for the service account, I can easily stop at any breakpoint I want.
Steve Jones
October 20, 2002 at 10:18 am
We have a Compaq SAN for some other items, but not the dbs. I have spoken recently to MS on another issue, a server with fiber channel disks, and they...
October 18, 2002 at 9:24 am
Slightly confusing, so let me state this simply and let me know if this is correct.
MAchine1 - SQL Server 7 server, has dts pacakge.
Machine2 - Remote Windows server machine containing...
October 16, 2002 at 9:48 am
No replication. Not sure why the values are creeping up, but pinged McAfee on the issue.
I suggested BIGINT, but since it's a 3rd party db and software, hestitant to do...
October 16, 2002 at 9:35 am
The "restore earlier log" means you are restoring out of order. Logs MUST be restored in the order they were taken.
If you are missing one, you can only restore to...
October 15, 2002 at 3:32 pm
I'd recommend calling MS, but they might tell you this.
detach the db. Create a new db and retry your restores.
Can't hurt.
Steve Jones
October 15, 2002 at 2:53 pm
You could build a query to generate a script for a table. Check the script library here (Resource | Scripts).
There isn't a way to be informed of all changes. You...
October 15, 2002 at 10:18 am
October 15, 2002 at 10:16 am
1) Search is on the top menu bar. It is hokey, but we haven't spent time fixing it as we have other priorities.
2) No. The only workaround is to build...
October 15, 2002 at 10:13 am
Timestamps (datatype) are not related to hours and dates, rather, they are incremental trackers for the transaction logs.
The datetime fields you have may indeed get duplicates when the times change....
October 15, 2002 at 10:07 am
Interesting topics, however getting a little off topic.
acudlip,
Can you repost your question in a new thread?
Steve Jones
October 15, 2002 at 10:05 am
It may be for you, but it threw me briefly, especially when the table involved was for a relatively new server.
What is simple for one person may not be for...
October 15, 2002 at 10:02 am
Viewing 15 posts - 37,036 through 37,050 (of 39,818 total)