Viewing 15 posts - 3,091 through 3,105 (of 3,221 total)
Using what was given including the recommendation of converting TEXT data type to VARCHAR you might want to try this:
You will have to insert your own code to update the...
June 15, 2008 at 3:30 pm
From this web site
http://www.sqlmag.com/Articles/Index.cfm?ArticleID=23911&DisplayTab=Article
Word has no OLE DB provider, so Data Transformation Services (DTS) can't easily access a Word document. Your best bet is to write a VBScript macro to...
June 15, 2008 at 6:11 am
SSC is a fine community and its members have helped me greatly, as I am sure it has helped others. My first thought is yes it should expand, and...
June 7, 2008 at 11:05 am
Using Sql Server Management Studio
1. Press F8 key to display Object Explorer
2. Right click on the database name
3. Select "Task"
4. Select "Generate Scripts"
5. Script Wizard...
June 3, 2008 at 8:43 am
You can use the SSMS (same tool) in the openning window there will be a line for Server name. Click on the down arrow on the right side of...
May 26, 2008 at 9:02 am
thought I would expand on my previous reply, and demonstrate how to view what would happen to insure that a deletion using the code is truly what you want .......
May 23, 2008 at 8:06 am
Do not know if this will be completely applicable to your problem but here is a technique (found on another SSC forum and being repeated by me) to delete...
May 23, 2008 at 7:35 am
As the author of this QOD, and a SQL developer NOT a DBA, I would like to thank all who entered this discussion. I think the question developed a...
May 20, 2008 at 8:38 am
From:
http://msdn.microsoft.com/en-us/library/ms188315.aspx
The scope of impersonation is explicitly defined in the statement.
The specified principal is specified as a LOGIN, a server-level impersonation,
or as...
May 15, 2008 at 9:25 am
Thank you, thank you ... when I read your last paragraph I actually laughed out loud, now my cube mates are wondering if I am OK or certifiable as...
May 14, 2008 at 8:21 am
Now Steve what did you mean to present to us with this editorial? (Pick one or more from the following)
1. A riddle
2. Insoluble problem
3. Inexplicable situation
Wikipedia:
Conundrum, a puzzle or...
May 14, 2008 at 7:43 am
Thanks for an Excellent question really rather simply once one understands how partitioning works........... learned a lot from it ...
May 13, 2008 at 7:15 am
It appears that most of the posted comments are from IT involved individuals. I would like to point out that companies themselves, if they are to survive, are rarely...
May 12, 2008 at 11:37 am
From BOL for 2008
http://msdn.microsoft.com/en-us/library/bb934198(SQL.100).aspx
SELECT SERVERPROPERTY ('FilestreamShareName')
,SERVERPROPERTY ('FilestreamConfiguredLevel')
,SERVERPROPERTY ('FilestreamEffectiveLevel');
FilestreamConfiguredLevel shows the currently configured level of FILESTREAM access, and FilestreamEffectiveLevel shows the effective...
May 12, 2008 at 8:37 am
If you are using SQL 2000 the following code should do
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
/**********************************************************
sp_GetBackupInfo without a parameter will report on all databases for a given...
May 12, 2008 at 6:42 am
Viewing 15 posts - 3,091 through 3,105 (of 3,221 total)