Viewing 15 posts - 37,171 through 37,185 (of 39,461 total)
Wow, someone is doing there job. I had assumed this was some sort of MD5 or other one way hash, but apparently not.
I guess NT Auth is starting to look...
July 8, 2002 at 10:22 am
Reinstall Visio. Haven't had issues with this, but I don't like it as a tool for modeling because it gets cumbersome and is not reliable for reverse and forward engineering.
ER/Studio...
July 8, 2002 at 10:08 am
Does this table have a different collation? Can you access it from Query Analyzer?
Might be a data issue.
Steve Jones
July 8, 2002 at 10:04 am
No. Easiest way to do this is run Trace and check for activity in that db. Maybe for a month. If nothing appears, then you can archive it.
Steve Jones
July 8, 2002 at 10:03 am
Completely agree with Brian (and thanks).
The GUI does cause slowdowns and issues in deployment. A few references (from my point of view):
http://www.sqlservercentral.com/columnists/sjones/wp_gui.asp
http://www.sqlservercentral.com/columnists/sjones/vcspart3.asp
Steve Jones
July 8, 2002 at 10:01 am
Or sp_spaceused.
Either will force you to do some calculation.
The full backup is also a good indication of space used. Run one for each filegroup.
Steve Jones
July 8, 2002 at 9:47 am
The only other (easy) way to do this is a bunch of triggers on all tables that insert the data into other tables. There are some tools (I think Lockwood...
July 8, 2002 at 9:46 am
Interesting and thanks. Glad I could summarize it.
I didn't have any bugs, but the warning from Erwin when I changed tables bothered me, so I decided to find out exactly...
July 8, 2002 at 9:42 am
I am always suspect of "I think it works differently"
EM may script different than what you would do, but that does not mean you are doing it wrong.
If you have...
July 3, 2002 at 2:49 pm
Profiler would be a better solution for tracking usage over some time period.
Steve Jones
July 3, 2002 at 2:47 pm
You're welcome and glad it worked.
Steve Jones
July 3, 2002 at 2:45 pm
You'd have to check through them. Somewhere down the line, I suspect that the table is being altered in some way. Is this with a temp table?
Steve Jones
July 3, 2002 at 12:32 pm
Does this happen everytime?
Can you post the table DDL and the stored proc?
Steve Jones
July 3, 2002 at 10:18 am
You need a system datasource. The SQL package runs under the SQLAgent account, which will not see your user DSN.
Steve Jones
July 3, 2002 at 10:17 am
Viewing 15 posts - 37,171 through 37,185 (of 39,461 total)