Viewing 15 posts - 4,561 through 4,575 (of 7,164 total)
Jeff Moden (4/8/2012)
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
April 9, 2012 at 12:42 pm
I ran the demo code and it works as advertised (i.e. emails a file with an xls extension) but when I open the attachment in Excel 2010 I receive this...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
April 9, 2012 at 12:33 pm
Perry Whittle (4/9/2012)
opc.three (4/9/2012)
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
April 9, 2012 at 12:11 pm
Perry Whittle (4/9/2012)
opc.three (4/9/2012)
however what if you had multiple files to move and missed one?
The database would not come online!
The only time this would differ in any way is with...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
April 9, 2012 at 12:02 pm
Perry Whittle (4/9/2012)
alter database DatabaseName set single_user with rollback immediate
go
-- Set databae Offline
alter database DatabaseName set Offline
go
---...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
April 9, 2012 at 11:48 am
Perry Whittle (4/9/2012)
opc.three (4/9/2012)
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
April 9, 2012 at 11:29 am
ravisamigo (4/9/2012)
Please advise how to find who restared the services and what might be the cause behind this change?
You will be able to see it in the Windows System Event...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
April 9, 2012 at 9:53 am
You're very welcome, happy to assist 🙂
To drive the point home, once again...remember this was a special case. You said you have read many articles about the perils of shrinking...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
April 9, 2012 at 9:47 am
Perry Whittle (3/28/2012)
SSRfromChennai (3/28/2012)
how to validate a windows login in domain through SQL queriesuse the stored procedure xp_logininfo
xp_logininfo only validates windows accounts after the SQL Server Login is created.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
April 9, 2012 at 9:42 am
Perry Whittle (3/30/2012)
You shouldn't need to set the database single user first, just issue the following
alter database set offline with rollback immediate
[/Code]
That would accomplish setting it offline and kicking out...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
April 9, 2012 at 9:38 am
This exact question came up on these forums a while back. You may be able to wiggle out of doing a full uninstall/reinstall, however do not take licensing advice from...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
April 9, 2012 at 9:10 am
Perry Whittle (4/7/2012)
As an extra option you could turn SORT_IN_TEMPDB on, this may offload somewhat to the TempDB rather than using the database filegroup
Ahhh, you beat me to it. I...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
April 7, 2012 at 6:54 am
For development and exploring on an XP workstation i would recommend SQL Server 2008 R2 Express Edition
http://www.microsoft.com/download/en/details.aspx?id=26729
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
April 6, 2012 at 9:56 pm
SQL Server 2008 does not use UTF-8 anywhere in terms of storing data internally, and neither does SQL 2012.
SQL 2008 stores unicode data using UCS-2, a subset of UTF-16LE...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
April 6, 2012 at 9:47 pm
Alternative:
EXECUTE...AT
http://msdn.microsoft.com/en-us/library/ms188332(v=sql.105).aspx
See example G. This way we can force a select to execute on the remote server.
If you have a table ready that matches the shape of the SELECT you...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
April 6, 2012 at 9:25 pm
Viewing 15 posts - 4,561 through 4,575 (of 7,164 total)