Viewing 15 posts - 1,021 through 1,035 (of 1,079 total)
one .exe file? are you calling an application? not sure what you are up to...
but....
In BI, add a process task, and point it to your .exe
save package into SSIS, and...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
November 20, 2009 at 1:38 am
once again, msdn has the answer!
http://msdn.microsoft.com/en-us/library/aa258803(SQL.80).aspx
"Permissions
DBCC SHOWCONTIG permissions default to members of the sysadmin fixed server role, the db_owner and db_ddladmin fixed database roles, and the table owner, and are...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
November 20, 2009 at 1:33 am
2009-11-19 17:36:28.870 spid153 The client was unable to reuse a session with SPID 153, which had been reset for connection pooling. This error may have been caused by an earlier...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
November 19, 2009 at 6:27 am
I am assuming you upgraded on the same server like you mentioned?
One question, maybe it doesnt mean anything, just a guess...
Did you leave your databases as level 80,90 compatibility? or...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
November 19, 2009 at 6:26 am
I have a database in that log file is 15 GB and data file size is 148 MB.
is your DB 15gb and log = 148? or the ther way around?
either...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
November 19, 2009 at 6:14 am
Definitely, just as long as you buy my plane ticket - from South Africa 😀
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
November 18, 2009 at 4:55 am
http://www.sqlservercentral.com/Forums/Topic538856-149-1.aspx#bm539530
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
November 18, 2009 at 4:20 am
run this first:
=========
DBCC SHOWCONTIG (table_name,index_name)
GO
=========
note the fragmentation and scan density.....
The execute;
==============
DBCC DBREINDEX('table_name',index_name,54)
==============
see any difference in logical frag and extent scan frag?
is your scan density = 100% ?
is your "Avg Pages...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
November 17, 2009 at 10:06 pm
Have to agree with Elliot on this one..
Have your server/network engineers assist you with the permissions on the folder, rather than making it more complicated for youself.
Also consider hosting the...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
November 16, 2009 at 10:34 pm
Hi, you've got quite a few options...
1. Maintenance Plans
2. Schedule a TSQL task job with relevant BACKUP.... code...
3. Build a SSIS package with the backup tasks.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
November 16, 2009 at 10:29 pm
Here you go...
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_create2_7eeq.asp
if that doesnt make any sense to you yet, post again, with you table and column names, will assist you gladly.
regards,
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
November 12, 2009 at 10:30 pm
try:
ALTER DATABASE database-name SET MULTI_USER
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
November 12, 2009 at 10:25 pm
http://www.microsoft.com/express/sql/download/
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
November 10, 2009 at 11:18 pm
ever tried changing your cleanup to specify smaller portions?
delete top 1000 from....
and make it run every 10 mins as well.
instead of
delete from table...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
November 10, 2009 at 12:02 pm
Easiest and best way to fix your issue: Buy a Ent License 😉
Personally I would uninstall and reinstall with the Std key.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
November 9, 2009 at 10:09 pm
Viewing 15 posts - 1,021 through 1,035 (of 1,079 total)