Posted
by mrblah
on Stack Overflow
See other posts from Stack Overflow
or by mrblah
Published on 2009-07-28T21:42:15Z
Indexed on
2010/03/17
14:01 UTC
Read the original article
Hit count: 326
When I generate scripts in sql server 2008 EM, it seems to insert the date/time in the script also.
How can I remove that?
© Stack Overflow or respective owner
as seen on SQL Authority
- Search for 'SQL Authority'
I am glad to announce that along with SQLAuthority.com, I will be blogging on the prominent site of SQL Server Magazine. My very first blog post there is already live; read here: Beginning SQL Server: One Step at a Time.
My association with SQL Server Magazine has been quite long, I have written nearly…
>>> More
as seen on Server Fault
- Search for 'Server Fault'
Hi,
I need to configure SQL Server aliases on a public-facing production server. To do that, I need to install SQL Server Configuration Manager.
I was not able to find a standalone installer for that, so I am having to install SQL Server 2005 Client Components. This approach is not ideal as we don't…
>>> More
as seen on ASP-PHP.net
- Search for 'ASP-PHP.net'
Modification technique pour le site de l'article.
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
I have a SQL Server 2008 DB. I want to extract SOME tables (and associated schema, constraints, indexes, etc) and create a SQL Server Express DB. It isn't a sync of the target, we stomp on it.
We ONLY need to do this in the file system (not across the wire). We are not fond of the synchronization…
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
i am connecting to sql server 2000 on a remote computer with a dotnet application, but when i try to open the connection it gives the following error:
When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections
What…
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
Is there a way to change the window title of my SQL Server Management Studio to display current server I'm connected to?
To know which DB I'm connected to, I have to scroll all the way up to see the name of the server and it's a pain..
Maybe there's an available plug-in or something.
>>> More
as seen on ASP-PHP.net
- Search for 'ASP-PHP.net'
Modification des liens pour t?l?charger l'outil SSMSE
>>> More
as seen on Server Fault
- Search for 'Server Fault'
Hi,
I need to configure SQL Server aliases on a public-facing production server. To do that, I need to install SQL Server Configuration Manager.
I was not able to find a standalone installer for that, so I am having to install SQL Server 2005 Client Components. This approach is not ideal as we don't…
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
I am having difficulties when trying to insert files into an MsSQL database. I'll try to break this down as best as I can:
What data type should I be using to store image files (jpeg/png/gif/etc)? Right now my table is using the image data type, but I am curious if varbinary would be a better option…
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
Hi!
I'm wondering if is there a way to force MSSQL Management Studio to produce a script like this:
ALTER TABLE Mytable
ADD MyCol bit NOT NULL
CONSTRAINT MyColDefault
DEFAULT 0 WITH VALUES
ALTER TABLE [dbo].Mytable
ALTER COLUMN MyCol2 int NULL
GO
when I alter a very simple property of a column…
>>> More
