Viewing 15 posts - 3,271 through 3,285 (of 6,679 total)
I can't really answer all of your questions, but just to clarify about your mirroring. The mirroring state will not go to suspended unless someone is issuing a command...
April 18, 2011 at 10:12 am
Probably not - what you really need to do on your laptop, if it is causing you issues is to set a reasonable max memory for that instance. That...
April 17, 2011 at 8:04 pm
Chrissy321 (4/14/2011)
April 14, 2011 at 5:48 pm
Okay, I am a bit confused here. In your original post, you stated that SQL Server was granted 44GB of memory, then your latest states 48GB - but, the...
April 14, 2011 at 1:57 pm
Yes, it can but you should review the article from microsoft. I don't have the link for the article, but you should be able to find it through google.
April 14, 2011 at 1:00 pm
I would say, most definitely not...
The transaction log will contain a record of all transactions that have occurred - and also contains the information needed to rollback a transaction and/or...
April 14, 2011 at 12:49 pm
That indicates that you probably have not run the instcat.sql updates on the 2000 box. Again, this is required when creating a linked server from a 2005/2008 system to...
April 14, 2011 at 12:45 pm
Grant Fritchey (4/14/2011)
April 14, 2011 at 12:36 pm
Did you run instcat.sql on the SQL Server 2000 box? This is needed if you are creating a linked server from SQL Server 2005 or higher back to a...
April 14, 2011 at 12:31 pm
I don't know of any specific tutorials - there are some, you just have to google them. I mostly just have learned on my own and don't really do...
April 14, 2011 at 12:15 pm
When you configure the flat file connection - set it up so text columns are defined with double-quotes. That will tell SSIS to ignore embedded commas in the data.
April 13, 2011 at 8:55 pm
annasql (4/13/2011)
Thanks all.When you say you use GUI to change dbowner, how do you do that?
Thanks
Right-click on the database in Object Explorer or Object Explorer Details - select properties...
April 13, 2011 at 6:40 pm
Most likely the reason why this doesn't work is because of the way the procedure is written. If you are using a cursor and not using a straight SQL...
April 13, 2011 at 12:13 am
When you executed your stored procedure, I am guessing that you opened it (modify?) or scripted it to a query window. Then you clicked on the execute button or...
April 12, 2011 at 8:13 pm
Lookup SUBSTRING and CASE in books online, here is an example:
SELECT ...
,t.unit
,CASE substring(t.unit, 3,...
April 12, 2011 at 8:05 pm
Viewing 15 posts - 3,271 through 3,285 (of 6,679 total)