Viewing 15 posts - 38,371 through 38,385 (of 49,571 total)
Oh, sorry. I misread. ISQLW is Query Analyser. It's ISQL that SQLCMD's a replacement for.
I'm curious why management studio's not acceptable. You can always open multiple copies of it if...
June 18, 2009 at 5:45 am
Dugi (6/18/2009)
And your vote is ...?
Neither. As I said in the other thread. Apples and grapefruit.
June 18, 2009 at 5:43 am
Are you sure the log backups are running? Check that someone hasn't added the WITH NO_TRUNCATE to the backup log statement.
June 18, 2009 at 5:16 am
Also posted here - http://www.sqlservercentral.com/Forums/Topic737277-61-1.aspx
June 18, 2009 at 5:14 am
Dugi (6/18/2009)
June 18, 2009 at 5:08 am
Open Books Online (the SQL help file) and look up Linked Servers. Or, if you prefer the online version: http://msdn.microsoft.com/en-us/library/ms188279(SQL.90).aspx
June 18, 2009 at 4:55 am
Don't shrink the database. See - http://sqlinthewild.co.za/index.php/2007/09/08/shrinking-databases/
If the log space isn't been reused, there's something still active in the older log records. Take a look at sys.databases. There's a column...
June 18, 2009 at 4:44 am
That trigger is written assuming there's only one row in the inserted/deleted tables. If more than one row was updated, the trigger fires once and there'll be more than one...
June 18, 2009 at 4:43 am
MVP is not a certification. You can't directly compare it to the MCM, MCA certs. Plus, there are only (iirc) 3 MCM certs available - Exchange, sharepoint, SQL Server. MVPs...
June 18, 2009 at 4:41 am
Best advice I can give you for an interview is relax, don't exagerate your abilities and don't be afraid to say 'I don't know', though have an idea how to...
June 18, 2009 at 4:34 am
Please post table definitions, sample data and desired output. Read this to see the best way to post this to get quick responses.
http://www.sqlservercentral.com/articles/Best+Practices/61537/
June 18, 2009 at 1:36 am
CREATE TABLE zzdbfiles.dbfiles (
....
)
INSERT INTO zzdbfiles.dbfiles
EXEC sp_MSforeachdb @command1 = 'select name, physical_name, state_desc, size, max_size, growth from ?.sys.database_files'
You have to explicitly create the table first. Select ... Into cannot use...
June 18, 2009 at 1:34 am
Manie Verster (6/17/2009)
June 18, 2009 at 1:27 am
RBarryYoung (6/17/2009)
June 17, 2009 at 2:08 pm
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic736889-17-1.aspx
June 17, 2009 at 2:00 pm
Viewing 15 posts - 38,371 through 38,385 (of 49,571 total)